Thread: Remove blank space in front of text in multiple cells at once
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
  
Posts: 189
Default Remove blank space in front of text in multiple cells at once
use the Trim formula to remove all the extra spaces
=TRIM(A1) the result will come in which ever cell you select for the answer
--
Thanks
Suleman Peerzade


"SMS" wrote:

I transposed data from multiple columns into rows. Most of the cells contain
text that has a blank space before the word. I want to remove this blank
space at once (without having to go into each cell and backspace)
Reply With QuoteReply With Quote