I am looking to extract a value from a text string and tried to use several combinations of right/left/mid/len functions but can't seem to get it to work. Here a scenario of what I would like the formula to accomplish:
AB FBO EFGH BARC MOLL GIVEN
Output desired: BARC
AB KLM IJKLM BA MOLL TAKEN
Output desired: BA
Any assistance is very much appreciated.