Hello everyone I am new to the page and I am in need of some Excel help. What I am trying to do is pull the second word out of a string of text if the first word matches. Here are the examples of the string of text I am working with.
eLearning AT3050 9:58am EST (New York......
OBSERVATION O200050 10:32am EST (New York......
What I need is Excel to look at the first word and if it matches "eLearning" to retrieve the AT3050 or if it matches "OBSERVATION" to pull the O200050. I tried using MID formula however, the first words are not the same length either are the second words. Now I am stuck. Can anyone help with this.
eLearning AT3050 9:58am EST (New York......
OBSERVATION O200050 10:32am EST (New York......
What I need is Excel to look at the first word and if it matches "eLearning" to retrieve the AT3050 or if it matches "OBSERVATION" to pull the O200050. I tried using MID formula however, the first words are not the same length either are the second words. Now I am stuck. Can anyone help with this.