T
Tom
Hi
Is it possible to use the Like operator as a worksheet-function?
Tom
Is it possible to use the Like operator as a worksheet-function?
Tom
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Daniel.M
Hi Tom,
The Search() function enables you to do this.
It is using a limited number of metacharacters: * and ?
Regards,
Daniel M.
The Search() function enables you to do this.
It is using a limited number of metacharacters: * and ?
Regards,
Daniel M.
T
Tom
Daniel
I'd like to make a worksheet function like this:
=If(B1 Like "##/###", True, False)
Tom
I'd like to make a worksheet function like this:
=If(B1 Like "##/###", True, False)
Tom
C
Chip Pearson
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
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
T
Tom
Thank you!
Chip Pearson said: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
H
Harlan Grove
Is it possible to use the Like operator as a worksheet-function?
Not unless you wrap it in a UDF. See
http://www.google.com/groups?selm=uPsppP0d#[email protected]