Switch First and Last Names

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

What is the excel formula to change John Brown to Brown, John? Thanks!
 
Karen,

Try this

=MID(A1&" "&A1, FIND(" ",A1)+1,LEN(A1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Hi,
try

=TRIM(RIGHT(A1,FIND(" ",A1)-1))&" "&TRIM(LEFT(A1,FIND(" ",A1)-1))
 
You must log in or register to reply here.

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

formula to switch last/first name around? 6
Automatic selecting and sharing of data accross worksheets 7
change full name to: title + initial(s) + surname 6
Spreadsheet - Deleting Duplicate Records - Self Checking 1
Filling a formula down-need correct cell reference 13
Deleting Repeated Rows 2
Matching Names 5
Team Role Rotation (number of team members is variable) 3

Back
Top