Hello,
i've been stumped to figure out my nested formula for the next instance of the same instance in a single cell,
here is my formula MID(AL2,SEARCH(“Oper”,AL2,1)+6,3) can someone please help me with the nested formula to find the next instance of the exact same thing? I know for the pros this is easy but i'm still trying to understand the way it works and would really appreciate someone's help to solve this problem i've been working on for a week.....I need the Oper ID's and the dates only but how????
the text looks like this:
"Oper: YW Date: 12/14/12 9:39am
mortgagee cls to sign, e-amiled to debbie for signature, also
just another correction april
Oper: KB Date: 01/21/13 11:55am
emailed for signature again.
Oper: KB Date: 01/22/13 10:38am
rcvd signed - emailed to company through website for processing."
Bookmarks