Removing spaces from cells
A simple Find/Replace should do the trick.
Select your range of UPC numbers
From the Edit Menu, choose "Replace"
In the Find What field, type a space
In the Replace With field, leave it blank
Click on Replace All
HTH,
Elkar
"CathyD" wrote:
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.
|