05-04-2018 13:15 PM
Thank you a ton for the great video, I have enhanced the formula to get the data with dynamic length:
"Divison Owner",Mid(Result,Find("Dvowr/",Result)+6+3,(Len(Mid(Result,Find("Dvowr/",Result)+6+3)) - Len(Mid(Result,Find("~!",Result)))))));
With this formula, I can get data with dynamic length.
Once again thank you for your detailed video.