View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Trevor Shuttleworth
 
Posts: n/a
Default Deleting a space between a group of Numbers & Letters in a cell

Melissa

why not just use a global Replace of " " for "" (nothing)

Regards

Trevor


"Melissa" wrote in message
...
I'm trying to delete a single space between a group od items:

ACE 12408 ------------I'm looking for ACE12408

I have over 10,000 lines so I'm looking for a shortcut.....Help ME
please!!!

Thanks