Extracting Initials from Multi-Word Last Names

[njpamdnc]

Dear Sir or Madam:

My name is Robert, and I am a middle school math teacher who is requesting your assistance with solving a frustrating problem. I have provided you with two scenarios for extracting initials from student names.

=IF(OR(COUNTIF(B101,"*SE*"),COUNTIF(B101,"*ESL*")),A101,"") gives me the result of "BP" for Budathoki, Pranik

=IF(OR(COUNTIF(B100,"*SE*"),COUNTIF(B100,"*ESL*")),A100,"") gives me the result of "BN" for Berrocales Noriega, Jacklyz

However, I want the result for Berrocales Noriega, Jacklyz to be "BJ". In other words, I want a formula to pull the first initial from the leftmost name in a field skipping through x amount of names until the formula is ready to pull the first letter of the first name. Any assistance you can provide will be greatly appreciated.

Sincerely,
Robert

 

[njpamdnc]

I don't understand
Post#4 contain your example (very poor example) and Power Query (Get&Transform) M code for that
what do you want more?
btw. there is no any worksheet formulas

I suggest you to update your profile about Excel version and OS

Ok...Thanks

 

[sandy666]

Ok...Thanks

You are welcome
As I can see you've XL2007 which is not supported by Power Query
Have a nice day

 

[kweaver]

Modifying my earlier code to:

=LEFT(A2,1)&MID(A2,FIND(",",A2)+2,1)

 

[Peter_SSs]

Another way would have been

=LEFT(REPLACE(A2,2,FIND(",",A2),""),2)

@kweaver
In case you were not aware, we now have specific tags for worksheet formulas: [CODE=xls][/CODE]