formula to extract variable initials from reference data

I have a list of references with initials , looking a formula to extract only the initials in next column.


20MI12345/Ab then extract the initials only ab,however sometimes there are 4 alphabets.

Some have reference only should be ignore

=IFERROR(RIGHT(E22,LEN(E22)-FIND("/",E22)),"")

in F1, copied down.

sorry, that formula was for F22.

here's one for F2.
=IFERROR(RIGHT(E2,LEN(E2)-FIND("/",E2)),"")

I just noticed some entries have - instead of /.
I'll write another formula to take care of either situation.

here's the one for F2 that takes care of both "/" and "-".

=IFERROR(IF(IFERROR(FIND("/",E2),0)>0,RIGHT(E2,LEN(E2)-FIND("/",E2)),RIGHT(E2,LEN(E2)-FIND("-",E2))),"")

@63falcondude

Thank you for this approach worked smartly




@modytrane

Formula works well but just a little draw back as below

20MI145435/0/SM 0/SM should read SM

Glad we could help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.