Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove hidden symbols in cells on excel?
We recieved large spreadsheet made up of part numbers, descriptions and
prices from our vendor. The cells have a hidden character and a space before the cell contents. This must be removed to allow loading into our inventory program. Is there a way to do this without clicking each sell and backspacing it out? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove hidden symbols in cells on excel?
try this
=TRIM(SUBSTITUTE(A1,CHAR(160),CHAR(32))) On Dec 12, 8:38*am, John C <John wrote: We recieved large spreadsheet made up of part numbers, descriptions and prices from our vendor. *The cells have a hidden character and a space before the cell contents. *This must be removed to allow loading into our inventory program. *Is there a way to do this without clicking each sell and backspacing it out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove symbols | Excel Discussion (Misc queries) | |||
How do I display sum hidden with #symbols by computer? | Excel Discussion (Misc queries) | |||
How to remove hyperlinks hidden in Excel spreadsheet | Excel Discussion (Misc queries) | |||
How do I remove a hidden space in Excel cells | Excel Discussion (Misc queries) | |||
How can I remove hidden empty text cells from Excel? | Excel Worksheet Functions |