REMOVE SPECIAL CHARACTERS FROM TEXT CELLS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

using excel 2003.. special characters causing errors when i upload
descriptions to my website... i think i am supposed to use the "clean
function" but the help menu is not helpful.. unless i am missing a step...
 
That would depend upon what the special characters are.

Download Chip Pearson's CELLVIEW add-in from

http://www.cpearson.com/excel/CellView.htm

Load through Tools>Add-ins.

Select the data and Chip's add-in will show you what the characters are.

If carriage returns you will be able to Replace them using ALT + 0010 or 0013

Most likely David McRitchie's TRIMALL macro will be of greatest assistance.
Cleans up what TRIM and CLEAN miss.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


Gord Dibben Excel MVP
 
Back
Top