Excel 2004 Mac Version - INSERT LINE BREAK IN INFORMULA
 

I have hundress of lines were I want to combine 3 columns of data (Address,
City, State) in a single cell, but I want to INSERT a line break so the text
is on three lines in the same cell. I have seen a post regarding the
Char(10) command, but this does not work for me. Is this a Mac Office
problem? or is the Mac Solution different? If anyone can help, I would be
very grateful. Thanks

Macs use CHAR(13) to break lines.

In article ,
Daniel wrote:

I have hundress of lines were I want to combine 3 columns of data (Address,
City, State) in a single cell, but I want to INSERT a line break so the text
is on three lines in the same cell. I have seen a post regarding the
Char(10) command, but this does not work for me. Is this a Mac Office
problem? or is the Mac Solution different? If anyone can help, I would be
very grateful. Thanks

JE,

IT WORKS!!! Thank you, thank you. You have saved me lots of time. I
sincerely appreciate the help. Best regards.

Dan

"JE McGimpsey" wrote:

Macs use CHAR(13) to break lines.

In article ,
Daniel wrote:

I have hundress of lines were I want to combine 3 columns of data (Address,
City, State) in a single cell, but I want to INSERT a line break so the text
is on three lines in the same cell. I have seen a post regarding the
Char(10) command, but this does not work for me. Is this a Mac Office
problem? or is the Mac Solution different? If anyone can help, I would be
very grateful. Thanks