line feed carriage return code equivalent to Excel 2007

B

beagle

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I want to find line returns in Excel cells with multiple lines of text (copied and pasted into cell). Using Excel 2007 for a PC, one can type Alt+010 using the numeric keypad in the FIND box, then place a unique identifying character such as a "|" in the REPLACE box.

How do you do the identical thing in Excel 2008 for Mac?
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I want to find line returns in Excel cells with multiple lines of text (copied
and pasted into cell). Using Excel 2007 for a PC, one can type Alt+010 using
the numeric keypad in the FIND box, then place a unique identifying character
such as a "|" in the REPLACE box.

How do you do the identical thing in Excel 2008 for Mac?
I don't think you can. You are not able to enter a formula (or the line
break character) in the find box. And, there is a further complication in
that the character that causes a line break within a cell in the Mac is an
ASCII 13, a carriage return. A line feed character (ASCII 10) is interpreted
as a space character within a cell on a Mac.
 
J

John McGhie

Copy the text out to Microsoft Word, munch it, and paste it back in... :)

Cheers


Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I want to find line returns in Excel cells with multiple lines of text (copied
and pasted into cell). Using Excel 2007 for a PC, one can type Alt+010 using
the numeric keypad in the FIND box, then place a unique identifying character
such as a "|" in the REPLACE box.

How do you do the identical thing in Excel 2008 for Mac?

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Carriage Returns 5
excel camera tool 1
Windows 2007 .xlsm files 7
is it possible to create a line break 2
Cell return 1
Soft Return in Excel:Mac 2008 2
In cell editing 2
How to stop Excel from rounding up 2

Top