Hi,
flip last name and first name using word vba
ex :- "Paris, City Of" to "City Of Paris"
this has to happen only if comma exists in the string.
Thanks in advance
Hi,
flip last name and first name using word vba
ex :- "Paris, City Of" to "City Of Paris"
this has to happen only if comma exists in the string.
Thanks in advance
Hi,
Use this macro :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
You possibly don't even need a macro for this. What's been described can be done via a wildcard Find/Replace, where:
Find = (<[! ]@>), (City [Oo]f)
Replace = \2 \1
karedog: The question has been posted in the Word forum, so it's probably not much good posting an Excel solution...
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks