line feed carriage return code equivalent to Excel 2007

[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?

 

[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.

 

[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]