Hi, I hope someone can help.

I have imported 4 columns from a table within an Access 97 database. I am having trouble with One column which is a "memo" field in Access. When the data imports, at the end of every paragraph within each cell (When there is a "Return"/new line) there is a little square box? This cannot be removed using the Find/Replace function as it is acutually a New Line symbol. The problem is that it is visible when printing?


Please help!!

Hi Matty,
See the TrimALL macro in
Rearranging Data in Columns
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
HTH,
David McRitchie
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Mattyb" wrote...
I have imported 4 columns from a table within an Access 97 database. I
am having trouble with One column which is a "memo" field in Access.
When the data imports, at the end of every paragraph within each cell
(When there is a "Return"/new line) there is a little square box? This
cannot be removed using the Find/Replace function as it is acutually a
New Line symbol. The problem is that it is visible when printing?