How do I transpose lastname, firstname with a macro?

S

Sharyn K

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

Helmut Weber

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I parse database "name" field into first and last name? 1
VBA to extract data from 2 excels 1
Converting to FirstName LastName 3
Sort Left to Right 1
Sorting contacts by Lastname, FirstName 3
Excel 2003 - Changing FirstName LastName to LastName, Firstname 3
Contacts - Default "File As" in MS Outlook 2010 - howto change? 0
Need to pull Combo Box Info and Populate Fields from Access (or SQ 1

Top