Change "lastname, firstname" to "firstname lastname" Find & replace

		Microsoft Office Forums > Microsoft Word > Word
Change "lastname, firstname" to "firstname lastname" Find & replace

FAQ

Thread Tools

Display Modes

03-11-2018, 10:20 PM

macropod

Windows 7 64bit Change "lastname, firstname" to "firstname lastname" Find & replace

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,514

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:29 PM.