Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Remove Carriage Return from imported Excel Spreadsheets

You import a spreadsheet and you noticed in some of your fields you have a little box with a question mark in it (see image below).  This is a Carriage Return (Alt+Enter in Excel).

Figure 1

  To remove create an UPDATE query and run against the offending field…

UPDATE YourTable SET FieldContainingCarriageReturn = Replace([FieldContainingCarriageReturn],Chr(10),Space(1))

 5,563 total views,  2 views today

Comments are closed.