|You could do it with formula if you are willing to put up with multiple formulas (or one really long Nested IF in 2007). I'm only going to do this for 3 letters. To get every combination for the 10 letters in MARKETINGS, you just need to expand on the concept.|
Here's the 2003 method...
Put MARKETINGS in A1
Put these in A2:A4:
Put this in C1:
As you enter letters in B1, the formula in C1 will determine the length of B1 and grab the corresponding string built by one of the formula in A2:A4.
As long as you have enough formulas in A2:A11 for the complete word, this formula can replace the Nested IF offered above:
When LEN(B1) = 1, it will return the value in A2, etc.