View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
wjohnson
 
Posts: n/a
Default how to remove spaces in a cell/column


Select your Column or Columns:
Go To EDIT - REPLACE - in the FIND - press the space bar 1 time.
Leave the REPLACE blank.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498789