How do I change name in single cell from last, first to first last

  • Thread starter Thread starter Dreamy
  • Start date Start date
D

Dreamy

In Excel 2003 how do I change a name in single cell that is last, first to a
first last name still in the same cell ?
 
You can't do it directly unless you use a macro. The easiest was is to flip
the names around with a formula and then
copy / paste special -> values
the correct names over top of the original...

The formula could be something like this...

=MID(A1,FIND(",",A1)+2,256)& " " & LEFT(A1,FIND(",",A1)-1)
 
Hi,

You can't really do what your asking without VBA. What you can do with a
formula is:

You can enter this in another cell and then copy and paste it over the old
text as values. In this example D1 contains the Last, First name

=MID(D1&" "&D1,FIND(",",D1)+2,LEN(D1)-1)

Copy this, select cell D1 and choose Edit, Paste Special, Values.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 

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

Reversing first and last names in one cell 5
change first name last name to last name first name 3
Excel VBA setting Ranges 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Converting Text Format from LAST NAME, First Name to First Name La 3
name listings 1
modifying name format within a cell 2
How do I separate first and last names into two columns? 2

Back
Top