I love these answers! thank you that is so very helpful.

I have been searching for something like this but with a twist.

What if you have numbers and letters in the cell. is there a way to tell it to show just the letters or the numbers as the answer???

thank you

PS: I did not want to start a whole new thread, I will hopefully get the answer here.
if not I will start one another time.