Thread
:
Strange New Line text when importing from Access 97
View Single Post
#
2
May 10th, 2009, 10:13 PM posted to microsoft.public.excel.links
David McRitchie
external usenet poster
Posts: 606
Strange New Line text when importing from Access 97
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?
David McRitchie
View Public Profile
View message headers
Find all posts by David McRitchie
Find all threads started by David McRitchie