REMOVE SPECIAL CHARACTERS FROM TEXT CELLS
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 ToolsAdd-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 On Fri, 1 Apr 2005 19:17:01 -0800, javila255 wrote: 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... |
All times are GMT +1. The time now is 07:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com