IN THIS LESSION I WILL TEACH YOU HOW TO GET LAST NAME IN ADVANCE EXCEL!!!

HERE ARE DATA

NEHA SHARMA

MEENA KUMARI

MANOHAR SINGH DUBEY

AMIT KUMAR TANDON


STEP1:- TO COUNT SPACE

FORMULA:-=LEN(A2)-LEN(SUBSTITUTE(A2," ",""))

STEP2:- SPACE REPLACE WITHJ NEW TEXT

FORMULA:-SUBSTITUTE(A2," ","&",B2)

STEP 3:- TO FIND COMMAN WORD

FORMULA:-=FIND("&",C2)

STEP 4:- LEN USE

STEP5:- GET RIGHT NAME

FORMULA:-=RIGHT(A2,E2-D2)


HERE ARE ONE FORMULA SOLUTION

=RIGHT(A2,LEN(A2)-FIND("&",SUBSTITUTE(A2," ","&",LEN(A2)-LEN(SUBSTITUTE(A2," ","")))))