The challenge this week is as follows: given a string in A2, return the single-word substring which immediately precedes the only occurrence within that string of a substring of the form XabcdY, where X and Y are either an asterisk or an obelisk and a, b, c and d are integers from 0 to 9.
- The string is delimited by single spaces
- Excluding the one substring of the form XabcdY, each of the other substrings may or may not have an asterisk or an obelisk at each end (providing of course that this will not result in more than one substring of the form XabcdY)
Solution next week. Best of luck!