Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Checking for spaces at beginning of string
I am having a problem using the left function to check for spaces at the beginning of a string. using this code: If Left(ActiveCell, 5) = " " Then activecell.offset(1,0).activate I am trying to skip any string that begins with 5 spaces. The code above does not seem to work to accomplish...- nwallac1
- Thread
- Replies: 12
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Parsing irregular text strings
I am trying to parse stock holdings for certain companies but I am running into trouble because they are not uniform in their form. The data has a general form but each company uses a slightly different style for the forms. These differences are hamstringing my efforts to effectively parse the...- nwallac1
- Thread
- Replies: 14
- Forum: VBA Visual Basic for Applications (Microsoft)
