Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using wildcard characters in find & replace | Excel Worksheet Functions | |||
FIND and REPLACE characters needed | New Users to Excel | |||
FIND and REPLACE characters needed | Excel Worksheet Functions | |||
How do I find replace special characters? | Excel Discussion (Misc queries) | |||
Find and replace unusual characters ... | Excel Discussion (Misc queries) |