ExcelBanter - Switch First and Last Names

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Switch First and Last Names (https://www.excelbanter.com/excel-worksheet-functions/255393-switch-first-last-names.html)

Karen

Switch First and Last Names

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

Mike H

Switch First and Last Names

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.

"Karen" wrote:

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

Eduardo

Switch First and Last Names

Hi,
try

=TRIM(RIGHT(A1,FIND(" ",A1)-1))&" "&TRIM(LEFT(A1,FIND(" ",A1)-1))

"Karen" wrote:

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

Teethless mama

Switch First and Last Names

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

"Karen" wrote:

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

All times are GMT +1. The time now is 07:28 PM.