Removing spaces

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?
 
M

MaxwellSmarty

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.
 

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

Space at end of multi page list to accommodate new entries 1
Wrapping and Anchors 0
Formating bolded text exclusively. 0
White space above heading inconsistently applied 1
(Word 2016/365) Removing white space between pages at a smaller zoom 0
Making id cards 1
Autocorrection pecularity 1
Remove non-space spaces? 3

Top