Posted to microsoft.public.excel.programming
|
|
Like operator as a worksheet-function
Thank you!
"Chip Pearson" schrieb im Newsbeitrag
...
Tom,
You can't do it that way. However, you can use the * and ?
wildcard characters in a COUNTIF, so try something like
=IF(COUNTIF(B1,"??/???"),TRUE,FALSE)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Tom" wrote in message
...
Daniel
I'd like to make a worksheet function like this:
=If(B1 Like "##/###", True, False)
Tom
"Daniel.M" schrieb im
Newsbeitrag
...
Hi Tom,
The Search() function enables you to do this.
It is using a limited number of metacharacters: * and ?
Regards,
Daniel M.
"Tom" wrote in message
...
Hi
Is it possible to use the Like operator as a
worksheet-function?
Tom
|