ignore first 10 characters with find and replace
Hi all, hope someone can help with this:
I'm working with a list of invoices, where the narrative for each is a name
followed by a period. I'm trying to convert any month namesin this string
into dates (e.g. "May" into "5/1-5/31") using find and replace through VBA,
but I keep coming across people with names that are months ("April", "May",
etc). Is it possible to make find and replace ignore the first 10 characters
of a string when searching for the text to replace?
I'm working on Office 2003
Any help on this would be gratefully recevied, I've been tearing my hair out
over this!
--
Regards,
Phil
|