extract last name

[manoj_th]

Parveen Kaur
Munish Abrol
Sandeep Chauhan
Varun Sachdeva
Jyoti Jhon
Anjali Singh

 

[Naresh Yadav]

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",10)),10))

 

[Deepak]

Check this..

 

[Marc L]

Hi ‼

Parveen Kaur
Munish Abrol
Sandeep Chauhan
Varun Sachdeva
Jyoti Jhon
Anjali Singh

So you gave no information to precise if you want to extract
first ou second word ‼ As initial post must be crystal clear …

To extract first word : =LEFT(A1,SEARCH(" ",A1)-1)

To extract second word : =SUBSTITUTE(A1,LEFT(A1,SEARCH(" ",A1)),"") …
​