The character that Excel uses to indicate a new line within a cell is
CHAR(10).


On Thu, 10 Feb 2005 12:45:03 -0800, "finnadat"
wrote:

ok on this thread I found someone with a similar problem -

http://www.microsoft.com/communities...816&sloc=en-us

I took the column over to word and replaced the two soft returns with one
soft return (didn't work - excel thought that the single soft return was a
cell break) and then a tab, but:
A. it should have a soft return, these are international addresses
B. it's a rather cheesy hack

"finnadat" wrote:

Exported 4000+ records from outlook to Excel - used the default map and it
lumped business address into one field. The problem is that at the end of
a
line there is a bold line in the cell and when you try to edit the cell the
formula bar shows it as a square. I've tried search and replace, but excel
doesn't have a special character feature and I'm @ wits end - any ideas?