Change First Name Last Name (First Last) to First Name Last Initial ( First L.)

[kznmrexcel]

Hi, everyone,

Is there a way to take a full name and convert it to a first name last initial without adding an additional column/step with "text to columns?"
I would like to convert from cell D2 , < John Doe > to cell F2 < John D. >
I appreciate any help with this.

Thanks,
Karen

 

[sandy666]

try=LEFT(D2,SEARCH(" ",D2)+1)

 

[Toadstool]

Hi KZNadalin,

Straightforward if they're all the correct format but I'd suggest checking your data for anomalies.

Book2
	D	E
1	Name	Result
2	John Doe	John D.
3	Sarah Jones	Sarah J.
4	Rip van Winkel	Rip v.
5	Jorge Da Silva	Jorge D.
6	Mr. J. Smith	Mr. J.
Sheet1

Cell Formulas
Range	Formula
E2:E6	E2	=LEFT(D2,SEARCH(" ",D2)+1)&"."

 

[Snakehips]

If there is any danger that D may contain a leading or extra spaced then use the formula with TRIM
If you need the Period ??? then use like F4

Book1
	D	E	F
2	John Doe		John D
3	Frederick Smith		Frederick S
4	Frederick Smith		Frederick S.
Sheet1

Cell Formulas
Range	Formula
F2	F2	=LEFT(TRIM(D2), FIND(" ",TRIM(D2),1)+1)
F3	F3	=LEFT(D3, FIND(" ",D3,1)+1)
F4	F4	=LEFT(D4, FIND(" ",D4,1)+1)&"."

 

[kznmrexcel]

That's perfect! Thank you so much!