Reversing name

[Jane Fischer]

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.

 

[Cbrine]

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]

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]

Sorry I should have explained that further. There is only first name a space and then last name.

 

[GorD]

Try this then

Book2
	B	C	D	E
7
8	Jane Fischer	Fischer Jane
Sheet2

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

 

[yee388]

something like the following?

Book3
	A	B	C	D
1	JohnDoe	Doe,John
2	SusieSmith	Smith,Susie
3	HarryPotter	Potter,Harry
4	Mr.T	T,Mr.
Sheet1

 

[Jane Fischer]

That works great. Thank you very much!

 

[barry houdini]

...here's another way

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

 

[erik.van.geit]

...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 !

 

[GorD]

Barry, i like that soloution too.

Very clever