Reversing Cell contents

[nsutton]

Hello,

I know this can be done quickly but i cant remember how!!.

Problem:
All i want to do is change a name in a cell from (for example)
Joe Bloggs
to
Bloggs, Joe

Many thanks

 

[schielrn]

Assuming it is always first name last name with a space, thsi should work:

=mid(a1,find(" ",a1)+1,len(a1))&", "&left(a1,find(" ",a1)-1)

This is untested, but let me know if it doesn't work, it should handle names like Hank Williams Jr. as well and convert it to Williams Jr., Hank.

Hope that helps.

 

[scottylad2]

Excel Workbook
	C	D
5	Joe Bloggs	Bloggs Joe
6	Sammy Smith	Smith Sammy
7	Derek Mack	Mack Derek
8	Aiden Caulley	Caulley Aiden
9	Romeo Thompson	Thompson Romeo
Sheet1

 

[nsutton]

Thankyou both

 

[Rick Rothstein]

Here is one more way...

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