Hi i'm tearing my hair out as i'm sure many of us visiting looking for excel answers are! you help is much appreciated
I have data which is non structured that i am trying to pull a date from in the format of 09/Sep/2018
i have thousands of rows but the date always appears after 10 different specific words, maybe there is a better way but i have been able to pull the date using the words and the mid functions as the examples below
at the moment it successfully does it but i have to do each word in a different column.
i would like to be able to nest the formulas somehow so i can have the results all in one column but i cant work out how? is this possible or is there a better way?
Thanks in advance
=MID($A2,FIND("dizzying ",$A2)+9,11)
=MID($A62,FIND("COMPLETE ",$A2)+9,11)
=MID($A287,FIND("jukebox ",$A2)+8,11)
=MID($A290,FIND("Yes ",$A2)+4,11)
Bookmarks