I have imported an excel file and I am wanting to extract / parse out two specific words from the field into another field. The "Int" or "Ext" do not appear in all the fields (which is fine). But when they do appear, I would like to move these words over to isolate them. Since the word is not always in the front of the string, I can't use my usual go to function of right (text: number of characters). Would the case function be the best way to extract these specific words from a spring of text in a field?
Thank you in advance for any help.