View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Cowley Phil Cowley is offline
external usenet poster
 
Posts: 2
Default 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