Wildcards in formulae
And if you wanted to really use wild cards...
Starts with LDN
=if(countif(a1,"LDN*")0, ....
or ends with LDN
=if(countif(a1,"*LDN")0, ....
or contains LDN
=if(countif(a1,"*LDN*")0, ....
Chiccada wrote:
Hello,
Im wondering if its possible for formulae to contain wild cards.
e.g.
i have a list of invoice numbers, some have LDN at the start some dont. What
i would like to do is make an IF formula which will find the invoices that
dont have LDN at the start. i was hoping that
'=if(a1=LDN*,a1,concatenate("LDN",a1))' would work but needless to say it
doesnt.
What, if anything replaces that * so i can search for part entires in cells?
Many thanks,
Rikki
--
Dave Peterson
|