View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CathyD CathyD is offline
external usenet poster
 
Posts: 2
Default Removing spaces from cells

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.