Happy Friday Oz!
I have a dataset where the data in nearly every cell in column A reaches excel's cap of 32,762 characters. Each cell contains a single customer's info, along with other useless data, repeated over and over in a pattern I can't quite decipher.
What I have noticed is, if I select the last occurrence of "Customer Info" as my mid point and then back up to the next left most occurrence of "MemberDirectory" as my left boundary, and then go forward to the first occurrence of "OHBA" as the right boundary (leaving "Customer Info" in the middle as my MID point), the customer information I need appears between these two boundaries. If anyone could help me write a formula to do this properly I would much appreciate it! I have attached a worksheet with some sample data. Thanks Oz!