View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jerry Jerry is offline
external usenet poster
 
Posts: 7
Default How to remove spaces from a word in a cell

I want to do it automatically for a group of cells.

for example, if the word in a cell is "a b c", after spaces are
removed, the new word in the cell will be "abc"

how to do it by using VBA? thanks!