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,
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.