1. how do I reveerse name order last name, first name to first name, last name
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.
2. change first name last name to last name first name - Excel
3. Changing a list from last name, first name to first name, last name
4. I need to swap last name, first name in a cell to first name last - Excel Functions&Formulas
5. last name first, first name last -- is there a code to combine 2 c
If you need both formats, why don'tyou use two helper columns, say D with formula =B2&", "&C2 and E with formula =C2&" "&B2 filled down as necessary? Regards, Stefi asonKezt rta: >> Thanks again for all your help. This group has been quite valuable to >> me. >> >> There are a couple of things I would like to do here. >> >> First, I have two columns of data. Col B is last names, Col C is first >> names. I would like to combine all that data into Col B with the Last >> Name First, (comma space) then First Name. >> >> Is there a quick macro I can write to do that? >> >> Then, after the data is in that format, is there a way to reverse >> column B so that the data is First Name First (space) Last Name (no >> comma)? >> >> That would be the best. I need the data both ways at different times >> depending on what I'm doing. >> >> Thanks again in advance for the advice. >> >> JasonK >> >> >>
6. last name first, first name last -- is there a code to combine - Excel
7. Sort 2 lists - one w/ last, first name // one w/ first, last name
I have 2 very large excel files that have pulled employee name, week ending and hours information. The information comes from 2 different systems. As a result, the names are not input the same way. I need to combine both lists and make sure that they mirror one another. Is that possible using a macro or sorting by "matching"? Ex. AGARWAL NIMISH, 10/1/2004, 20 hours // NIMISH R AGARWAL,10/1/2004, 20 hours
8. Last name first first name last - Excel Functions&Formulas