Last Initial, First Name

[leeshjay]

I have a list of people in the Last Name, First Name format. So everyone doesn't acquire last names, I've been asked to change it to Last Initial, First Name. Is there an equation for that?

Ex. Smith, John to S, John

Thank you!

 

[kweaver]

Is this what you're looking for?

Book2
	A	B
1	Smith, John	S, John
2	Leesh, Jay	L, Jay
3	Jones, William	J, William
Sheet2

Cell Formulas
Range	Formula
B1:B3	B1	=LEFT(A1,1)&RIGHT(A1,LEN(A1)-FIND(",",A1)+1)

 

[leeshjay]

Is this what you're looking for?

Book2
	A	B
1	Smith, John	S, John
2	Leesh, Jay	L, Jay
3	Jones, William	J, William
Sheet2

Cell Formulas
Range	Formula
B1:B3	B1	=LEFT(A1,1)&", "&RIGHT(A1,LEN(A1)-FIND(",",A1))

This is PERFECT. Thank you so much!

 

[Fluff]

Bit late, but another option

=REPLACE(A1,2,FIND(",",A1)-2,"")

 

[leeshjay]

Bit late, but another option

=REPLACE(A1,2,FIND(",",A1)-2,"")

Thank you so much!

 

[Fluff]

My pleasure.