I have a string of characters, typically in the range of 120 characters long. Towards the end of that list there will be a string that goes WG?G, where ? is any character. I basically want to find where in the string this WG?G string is. That's easy enough with a Search formula but occasionally I have a string of characters where that WG?G string occurs multiple times. I want to find the last occurrence of this. I thought I might be able to use a Find/Substitute solution as described here but I can't get that to work as the substitute formula doesn't work with the ? wildcard, i.e. if I try a substitute formula with WG?G it searches for a question mark rather than for 'anything' at the 3rd position in that string. Any ideas on how to work around this problem? Trying to avoid doing this without a macro. I had thought about reversing the sequencing and then searching for the first occurrence but reversing a sequence without a macro is not easy either.