I have a column that has data where most cells in the column contain only a
number, but some cells contain a one to three letter designation for example
LT 50835, DLT 6035, or 8227P. I am trying to figure our a formula that would
let me extract just the letter designation into a new column. I assume it is
a and lookup with an IF statement but I can't get it figured our. The ones
without a number would be assigned the negative and I know it would be If x=x
then a, or x=y then b, or x=z then c, else m. But I just can't figure out
how to make it look for just the letters within the lookup cell for each row.