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 |
Technology Tips and News
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 |
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