Hi All,
I'm completely new here so first hello and I'm sorry for not contributing before asking for help (not that I have much to contribute, I'm not very good with Excel).
So I have a list of words that all vary in length and I need a way to be able to filter them based on the first, second and last characters in the word.
I.e. I input 1st letter = P, 2nd letter = I, last letter = T and it would bring up all relevant words from the list (pilot, pivot, pinterest etc.).
I would like it to be automatic if possible so I can just type in the letters and the list instantly appears.
Would anyone be any to help me out?
Thanks in advance!
Jack
Bookmarks