How do I transpose lastname, firstname with a macro?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sharyn K - 22 Jan 2005 01:53 GMT

I need a macro that will transpose and change case of LASTNAME, FIRSTNAME to
Firstname Lastname. Anyone know how to do this?

Reply to this Message

Jezebel - 22 Jan 2005 03:34 GMT

You don't need a macro. Find and replace will do it (or you can call Find
and Replace from a macro). If each name is on a separate line:

Enable wildcards.
Search for: ([!,]@), ([!^013]@)^013
Replace with: \2 \1^013

> I need a macro that will transpose and change case of LASTNAME, FIRSTNAME to
> Firstname Lastname. Anyone know how to do this?

Reply to this Message

Helmut Weber - 22 Jan 2005 11:24 GMT

Hi,

a million ways to do that, but no perfect method, probably
Where in the doc is "LASTNAME, FIRSTNAME" to be found?
What is the structure of the doc?
Are there other words in capital letters?
Are there no names like O'GROATS, JOHN F. ?
etc...

Greetings from Bavaria, Germany

Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word XP, Win 98
http://word.mvps.org/

Reply to this Message