Formula to change name format

J

jsnyder

I have the name:

John Smith

and I would like a formula that changes it to:

Smith, Joh
 
C

Claus Busch

Hi,

Am Tue, 4 Sep 2012 20:35:41 +0000 schrieb jsnyder:
John Smith

and I would like a formula that changes it to:

Smith, John
Click to expand...

your name in A1, then try:
=MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1)


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Fill Word Documents 4
Delete all data after a symbol in a field 0
Creating Forms 0
Vlookup and Countif 0
Formula to change Name format 2
Unique Value Count in 3 Columns Using Search Criteria 0
Matching Names 7
subtotal data from 2 columns into 3rd column 1

Top