Thread: Removing Space
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege Beege is offline
external usenet poster
 
Posts: 66
Default Removing Space

Tom wrote:
Hello - When I import data, there is a space in front of the first
character in a cell. Would like to know if there is a visual basic
code to remove this space. I already have a code which removes all
spaces, now need code to remove the first space and leaves the other
spaces in place.
Thanks,
Tom


ltrim?

beege