Hello,
I'm trying to get a cell to show a message if two other cells contain some
specific text:
ex.
=IF(AND(A3="RRA05*";C3="KRF");"Tipo 4";"Tipo 1")

but I'm having trouble with the wildcard *

I have already tried ...A3="RRA05?????"... as this article code is always 10
digit long, but it also doesn't work

Should I format the cells in any specific way (as "text" or something else)
so it will work?

Thank you very much in advance, for all the help provided

Susana