how do I reveerse name order last name, first name to first name, last name

[Don Smith]

I have a long database, 27k with names that I want to mail to. The
list is last name, first name. I want to do a global change to first
name, last name. I also want to add "Mr" to it. For example: the
list now is Smith, John. I want to change it to Mr. John Smith for
the entire list.

 

[Scott]

Assuming there is only one comma in each:

="Mr. "&TRIM(MID(A1,FIND(",",A1)+1,LEN(A1)-FIND(",",A1)))&"
"&LEFT(A1,FIND(",",A1)-1)

Note that some of the women might be offended.... 27k names, all male?

Scott

 

[Jim Cone]

All personal friends I assume?
--
Jim Cone
San Francisco, USA


"Don Smith" <[email protected]>
wrote in message
I have a long database, 27k with names that I want to mail to. The
list is last name, first name. I want to do a global change to first
name, last name. I also want to add "Mr" to it. For example: the
list now is Smith, John. I want to change it to Mr. John Smith for
the entire list.

 

[Don Smith]

Actually they are all Doctors, so M/F is not an issue, or is it?

 

[Don Smith]

Sorry, where do I put this express to make that change?

 

[Jim Cone]

The actual issue is "spam".
Jim Cone
San Francisco, USA


"Don Smith" <[email protected]>
wrote in message
Actually they are all Doctors, so M/F is not an issue, or is it?

 

[Bob Phillips]

=TRIM(MID(A1&" "&LEFT(A1,FIND(",",A1)-1),FIND(",",A1)+1,255))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Scott]

Actually, if it's a mailing, it's not spam... but it is potentially
junk mail. The concepts are different, even if the activities
sometimes overlap.

Would you be offended to be called Mrs. Don Smith or Ms. Don Smith?
Chances are reasonable that you'd be offended to some degree. If not,
then don't worry about it. Otherwise, someone called Mr. Jane Smith
might be offended, resulting in them taking a dim view of your
advertising. If they are all doctors, the use "Dr.". If you're not
sure, you might have to find something neutral, but applicable.

The actual usage... create an extra column beside your existing column.
Put the formula in the first cell beside the first name. (Adjust it
from referencing A1 if the name isn't in A1). Copy the formula all the
way down. Highlight the whole column with the formulas. Edit -> Paste
Special ... -> Values. At this point you can delete the original
column.

Note: If you're not all that proficient with Excel, I'd recommend you
make a backup copy of your spreadsheet, so you can go back to it and
try again.

Scott

 

[Don Smith]

Sorry, I have been playing with this for two hours and am getting
close, but . . . . If I copy the formula to the first column, and
the names are in the second column, how do I get the formula to work?

 

[Scott]

That's where the Paste Special -> Values comes in. This converts
formulas to the value they result in. You can highlight the whole
column with the formulas, and then either Paste Special -> Values
there, or do so in the original column. At that point, wherever you
pasted it should have the names the way you want them, and you delete
the other column. Sorry, not sure how else to describe it. You might
search on the net for an illustrated walk-through for Paste Special.

Scott