Removing spaces from cells
CLEAN will not remove spaces nor invisible html characters
--
Regards,
Peo Sjoblom
"Gaurav" wrote in message
...
assuming your code in in A1. in B1 write =CLEAN(A1) and drag it down. you
can then copy and paste special|values.
Does that work?
"CathyD" wrote in message
...
I have a very large spreadsheet--like 35,000 items long including 12-digit
UPC. The problem alot of them have spaces in between the numbers. We
need
to import without any spaces.
Anything built into excel to do this easily--or is it better to just buy
the
add-in.
|