Extract text. Can you please help me. How can I extract data for Col B and Col (Front Name & Back Name)

[selvamnarayanan]

Full Name	Front Name	Back Name
Ali bin Muthu	Ali Bin	Muthu
Samsuri Binti Adnan	Samsuri Binti	Adnan

 

[arthurbr]

Which is your XL version please ? Your profile does not say ( recent versions have newer functions)

 

[SunnyAlv]

idk what ur excel version and i hope using newest version,

Like This ?

Cell E2

=TEXTJOIN(" ",,TEXTBEFORE(A2," "),TEXTBEFORE(TEXTAFTER(A2," ")," "))

Cell F2

=TEXTAFTER(TEXTAFTER(A2," ")," ")

 

[arthurbr]

If you always have the same formatting ( and the correct XL version) try

=TEXTSPLIT(SUBSTITUTE(A1," ","%",2),"%")

 

[selvamnarayanan]

Which is your XL version please ? Your profile does not say ( recent versions have newer functions)

Sorry my mistake. I am using Excel 2019

 

[selvamnarayanan]

Which is your XL version please ? Your profile does not say ( recent versions have newer functions)

Sorry my mistake. Excel 2019

 

[Fluff]

I am using Excel 2019

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)