Hi, I want to use the true function to check if the Value - number and letter combined - can be found in the cells 1 to 10 and if so, please give the line of the value

1
2
3
4
5
6
7
8
9
10
Formular
8	'=(A12=A1 or A12=A2

VLookUp.

Of course - Thank you very much

Hi TheFinCo,

Do you mind giving us more detailed sample?

Do you only want to determine if the cell includes the letter, we can use this:

=IF(A1="","",IF(ISNUMBER(A1*1),"Not have","Have"))

Or do you want to get the number value or letter value in a mixing cell?

If yes, we may try to the formulas below:

Get letter: =LEFT(A1,LOOKUP(,0/(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)>="a"),ROW(INDIRECT("1:"&LEN(A1)))))

Get number:=SUBSTITUTE(A1,B1,)

If I misunderstood something, please feel free let me know.

Regards,

George Zhao
TechNet Community Support