View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
john the confused john the confused is offline
external usenet poster
 
Posts: 51
Default white space deletion

If you need to remove all the spaces you can do it using find & replace on
the edit menu.

Put a space in the find box and nothing in the replace box and then click
replace all.

John

"JOMARFL" wrote:

Greetings,

I have gone through the help section in Exel trying to understand how to
delete white spaces in Column A. Column A is a list of employee numbers and
after each number is a space. How do I delete that space in one big sweep
since there are over 700 different numbers listed, all with a space after
them?
Thanks