Last name, first name

  • Thread starter Thread starter Mich
  • Start date Start date
M

Mich

I have a list with lastname, firstname in a cell. I would
like to change it to firsname lastname. Any clues?

officexp.

Thank you.
 
Mich -

Insert a column after your name column, highlight the name
column, go to Data, Text to Columns, Delimited, select
comma, finish. This will give you two columns, lastname,
firstname. Insert a column before your lastname column.
Move the firstname column to the new column. Your third
column should now be blank. Enter in the formula
=CONCATENATE(,A1," ",B1)in the third column. This will put
your firstname space lastname in the third column. Then
delete the first two columns. There may be an easier way
to do this, but I know this works

Carole
 
Back
Top