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

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

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,447
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,447
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
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,176,530
Messages
5,903,602
Members
435,037
Latest member
AnneDerks

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