Search results for query: *

While using ltrim would be nice, it is not a possibility in this case. I am trying to eliminate those cells that begin with 5 or more spaces from my search. I chose 5 as a safe number that would distinguish the cells I want from the cells I do not want. thus, I am still having many problems.

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...

Thanks Stevexff. unfortunatly I have not been able to try it out yet. I am using Excel (VBA) to try and parse this stuff and regexp does not seem to be functional for VBA. I read somewhere that there is a way to get regexp for VBA but, i have not figured out how. Does anyone have any advice?

I am unfamiliar with regex-based code, so this is all new. The fields I am interested in are name, the first number (after COM) and the third number. I have tried using com as a marker for position in the file, but I found that there are other words used besides COM and common. here are some...

Right, sorry about that. I am using Excel to try to do this. I have tried the " " delimiter, but problems arrise because fields are sometimes separated by a single " " if they are quite long. This leads a " " delimiter to mess up an entire entry because everything will be off by one entry.

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...