Thread: How do I delete an extra space in every cell in a column?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
jbach11
 
Posts: n/a
Default How do I delete an extra space in every cell in a column?

Use the trim function, reference the cell that you want trim and copy
the formula down. Once you have the new data (trimmed) just copy and
post over the data.


--
jbach11
------------------------------------------------------------------------
jbach11's Profile: http://www.excelforum.com/member.php...o&userid=33722
View this thread: http://www.excelforum.com/showthread...hreadid=535027

Reply With QuoteReply With Quote