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? |
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? |
All times are GMT +1. The time now is 06:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com