Been searching the forums and can't find what I'm looking for.
Have a large data base of names and they have been put in multiple ways except for the PROPER way.
File name would be like
Mary Jane - One Time - Room1
Or it may be:
Jane Mary - One Time - Room1 (forgot to put comma in)
Or it may be:
Sears, Pete & Jane Mary - One Time - Room1
So I would like to search names by either:
Mary Jane (or) Jane Mary
and replace any instances of them with Jane, Mary
Would appreciate any help
Thanks