Removing spaces

  • Thread starter Thread starter Ric
  • Start date Start date
R

Ric

I have been given some product UPC numbers in a format
similar to 7 94080 10003 2
I need to get rid of the spaces between numbers. I have
tried the 'TRIM' function to no avail.
Any ideas?
 
Highligh the total column or cells that you want to
correct. Then go to EDIT menu then REPLACE. From there
put a space in the FIND area then nothing in the replace
area. Then click replace all. It should take care of it.
 
Back
Top