View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wjd01 wjd01 is offline
external usenet poster
 
Posts: 4
Default Removing preceeding spaces

When opening specific text documents in excel, the text is
captured with 6 or 7 preceeding spaces (this is
expected). I'm looking for a macro that will remove only
the preceeding spaces, but not touch any spaces that
appear after the first character of text. Is there a
macro that can remove these? I have tried to setup a
macro that copies and pastes values...etc. but to no
avail. The spaces are always carried along.

Thanks for your suggestions.

wjd01