#1
|
|||
|
|||
Change "lastname, firstname" to "firstname lastname" Find & replace
Hello all! Thanks in advance for your help - I am very grateful.
I have a large text file with names and emails which I am trying to unify so that I can add them as contacts into mailchimp. It looks like this: "Allen Shawn" <AShawn@bennington.edu> "Jane Austen" <spettee@verizon.net> "Kessler, Judy" <jkessler@vno.com> "Kipper, Judith" <jkipper@iwa.org> ...... ..... The names don't have a unified format. How do I use wildcards correctly to change everything to "Firstname Lastname"? Thank you! |
#2
|
||||
|
||||
There is no way for a Find/Replace to 'know' what is a first name or a last name. That said, it appears from your data that the entries starting with the last name also have commas, whereas the others do not. In that case, you could use a wildcard Find/Replace, where:
Find = (^034)([!,^034]@), ([!^034]@)\1 Replace = \1\3 \2\1
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
find & replace, find and replace |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Replace "comma" with "and" in line of text | audioman | Word VBA | 7 | 01-21-2016 03:11 PM |
Change "File As" and "Display As" format | davesp | Outlook | 0 | 10-14-2014 12:10 PM |
lastname and firstname | kamakshi | Excel | 5 | 09-21-2013 11:14 AM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
How do I change the "and" to "or" with multiple Rules (and Alerts)? | bschimmel | Outlook | 0 | 11-16-2009 05:26 AM |