How to extract text between two characters in Excel

Basically I am trying to extract product information from between "en_US@" and ";" so for example if I was given "en_US@Terminal Block;" I would want Terminal Block retued. My method for doing this was =MID(B2, FIND("en_US@",B2)+6, FIND(";", B2, FIND("@", B2)+1)-FIND("@",B2)-1) which is correct however my question is can I write code to include "??_??@" as an option for the code to look for so I would look for either "en_US" or "??_??" to start the text extraction.

Recent Questions...