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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing spaces from cells 4
Remove non-space spaces? 3
Finding selected numbers within a master list 2
trim cells with space in betwen numbers in cell 2
Excel Convert Multiple Rows into Multiple Columns 1
Formatting a lookup 5
if and replace function? 5
Help with Duplicates 6

Back
Top