Import characater from Excel

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi All

When importing an excel table into Access 2002 we notice that some entries
in the imported field have a small square character at the end of the text
entry.

How can that character be removed - have tried replace but it says it can't
find the character

TIA

Tom
 
Hi,
most likely that is a carriage return.
You can try to run the replace function twice. The carriage return and line
feed symbol generally appear next to each other, but not always, so try:

=Replace ([FieldName], Chr(13), "")
and
=Replace ([FieldName], Chr(10), "")

HTH
Good luck
 
Back
Top