Reversing name

Jane Fischer

Board Regular
Joined
Feb 6, 2006
Messages
85
I have a column that contains first and last name. Is there a way to switch it to last name then first? Someone sent one of our users a file and she needs it by last name.
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Cbrine

Well-known Member
Joined
Dec 2, 2003
Messages
3,196
Jane,
Can you post an example of what you have? and what you want to have? Does the name have a comma seperator, a space? If it's a space are there names that are 3 names?
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
Are all the entries first name followed by a single space followed by surname, or do you have entries with middle initials etc. ??
 

Jane Fischer

Board Regular
Joined
Feb 6, 2006
Messages
85
Sorry I should have explained that further. There is only first name a space and then last name.
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446

ADVERTISEMENT

Try this then
Book2
BCDE
7
8Jane FischerFischer Jane
Sheet2


formula is - =RIGHT(B8,LEN(B8)-FIND(" ",B8))&" "&LEFT(B8,FIND(" ",B8))
 

Jane Fischer

Board Regular
Joined
Feb 6, 2006
Messages
85

ADVERTISEMENT

That works great. Thank you very much!
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
...here's another way

=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1))
another way ?
that's the TOP :)
sense of logic combined with Excel skills
only 3 function calls

Bravo !
 

Forum statistics

Threads
1,141,756
Messages
5,708,333
Members
421,566
Latest member
7Nabisco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top