Thread: How do I apply LTRIM to entire Sheet?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
D[_6_] D[_6_] is offline
external usenet poster
  
Posts: 34
Default How do I apply LTRIM to entire Sheet?
Hey guys-
I have an entire sheet filled with data. Many columns/rows have spaces at
the beginning of the cell. Many cells have multiple words in them, so a
simple Find/Replace wont work. I need to use LTRIM across the entire
worksheet so it deletes out all the leading spaces. How can this be done
easily???
Thanks
D


Reply With QuoteReply With Quote