If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Strange New Line text when importing from Access 97
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!! -- Mattyb |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|