Export Data into Excel Spreadsheet - hard line break symbols!

C

CherylH

Hi all,
I've exported data out of an Access DB (table) into an Excel spreadsheet.
All went well, except for one column where there is a box with a ? mark in it
(which I've concluded represents a hard line break). How can I delete this
(box and ?) in my excel spreadsheet - and, if I can delete it, will it wipe
out the hard line breaks (i am assuming it will).

Thank you!
Cheryl
 
K

Ken Snell \(MVP\)

ACCESS uses the combined "carriage return" (Chr(13)) and "line feed"
(Chr(10)) characters for a line break. EXCEL uses just Chr(10). So, the way
to "fix" the data during the export is to use a calculated field for that
field, and use an expression with Replace function to replace Chr(13)
characters with "" character.

ThatField: Replace([OriginalField], Chr(13), "", 1, -1, 1)
 
Top