tried, but they aren't physical characters - excel doesn't seem to understand
two soft returns.

" wrote:

hi,
if it is just a line that shows up as a square, do a find
and replace all.

-----Original Message-----
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?
.