Extract first initial (and full stop) and surname - from a full name

[zugfrig]

Hi, ive tried to explain my need in the pic below... im sure this will be a piece of cake for somebody, but i was unable to work it out.

 

[LegendaryAxe]

Try this:

Book2
	A	B
1	Raw Data	What I Want
2	Ned Moyle	N. Moyle
3	Nick Haynes	N. Haynes
4	Jarryd Lyons	J. Lyons
5	Zane Trew	Z. Trew
6	Jake Kelly	J. Kelly
7	Brandon Ellis	B. Ellis
8	Brayden Preuss	B. Preuss
9	Brad Crouch	B. Crouch
10	Andrew Gaff	A. Gaff
11	Jaxon Prior	J. Prior
Names

Cell Formulas
Range	Formula
B2:B11	B2	=LEFT(A2,1)&". "&RIGHT(A2,LEN(A2)-SEARCH(" ",A2))

 

[jolivanes]

You should include your office version so helpers can give you the best possible answer pertaining to your version.
If you have 365, which I don't have, have a looke here.

TEXTSPLIT function - Microsoft Support

support.microsoft.com

 

[jolivanes]

And a similar but different approach from Legendary

=LEFT(A2, 1) & "." & MID(A2, SEARCH(" ",A2),99)

 

[zugfrig]

Thankyou sir,

Try this:

Book2
	A	B
1	Raw Data	What I Want
2	Ned Moyle	N. Moyle
3	Nick Haynes	N. Haynes
4	Jarryd Lyons	J. Lyons
5	Zane Trew	Z. Trew
6	Jake Kelly	J. Kelly
7	Brandon Ellis	B. Ellis
8	Brayden Preuss	B. Preuss
9	Brad Crouch	B. Crouch
10	Andrew Gaff	A. Gaff
11	Jaxon Prior	J. Prior
Names

Cell Formulas
Range	Formula
B2:B11	B2	=LEFT(A2,1)&". "&RIGHT(A2,LEN(A2)-SEARCH(" ",A2))

Thankyou sir, thats a great help

 

[alansidman]

You could also try using Flash Fill. Look at this video.

Google Search

 

[Scott Huish]

=REPLACE(A2,2,FIND(" ",A2)-1,". ")