Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2018, 09:49 PM
delgesu delgesu is offline Change "lastname, firstname" to "firstname lastname" Find & replace Mac OS X Change "lastname, firstname" to "firstname lastname" Find & replace Office 2016 for Mac
Novice
Change "lastname, firstname" to "firstname lastname" Find & replace
 
Join Date: Mar 2018
Posts: 1
delgesu is on a distinguished road
Exclamation 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!
Reply With Quote
  #2  
Old 03-11-2018, 10:20 PM
macropod's Avatar
macropod macropod is offline Change &quot;lastname, firstname&quot; to &quot;firstname lastname&quot; Find &amp; replace Windows 7 64bit Change &quot;lastname, firstname&quot; to &quot;firstname lastname&quot; Find &amp; replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

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
Change &quot;lastname, firstname&quot; to &quot;firstname lastname&quot; Find &amp; replace lastname and firstname kamakshi Excel 5 09-21-2013 11:14 AM
Change &quot;lastname, firstname&quot; to &quot;firstname lastname&quot; Find &amp; replace 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft