Finding a text string and removing characters from the string
Posted on 2004-04-10
I'm sorry to bother you guys with some thing this feeble but here goes:
I am having to import a word table into excel, then I want to strip out only the information i want. some of the tables are different lengths and rows etc.
So I search for the text ' meeting dates" which returns for example
"MEETING DATES: 9th - 15th January 2003"
I then copy this string to another sheet. Next, I then want to trim it to 15th January 2003 etc.
i have tried Left, Right etc but none of them seem to work, is it because I am trying to do this function on a selected coloumn instead of cell by cell? I really havent a clue.
Another thing to note is that the date in the tables can change. When I import the word document i generally get around 80 tables imported into Excel.
I dont think there is any point at looking at my code because it si sooooo bad, I need soem fresh code with some help, really it would be most appreciated
Ronald, yep I really am lost