Show Name initial John Smith Doe as JSD

Hi Expert,

This formula not working
Left(A9.RAW)&mid(A9.RAW,find(" ",A9.RAW)+1,1)

An example I want to show only the name initial for JOHN SMITH DOE

and display as JSD in another cell.

Appreciate your help,

This should work for you:

UPPER(LEFT(A1,1)+MID(A1,FIND(" “,A1),1)+MID(A1,FIND(”~",SUBSTITUTE(A1," “,”~",2)),1))

If you need more than 3 initials, you can add another MID(A1,FIND("~",SUBSTITUTE(A1," “,”~",2)),1) and change the 2 to a 3 etc.