D Daniel.M Dec 12, 2003 #2 Hi Tom, The Search() function enables you to do this. It is using a limited number of metacharacters: * and ? Regards, Daniel M.
Hi Tom, The Search() function enables you to do this. It is using a limited number of metacharacters: * and ? Regards, Daniel M.
T Tom Dec 12, 2003 #3 Daniel I'd like to make a worksheet function like this: =If(B1 Like "##/###", True, False) Tom
C Chip Pearson Dec 12, 2003 #4 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, 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 Dec 12, 2003 #5 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 Click to expand...
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 Click to expand...
H Harlan Grove Dec 12, 2003 #6 Is it possible to use the Like operator as a worksheet-function? Click to expand... Not unless you wrap it in a UDF. See http://www.google.com/groups?selm=uPsppP0d#[email protected]
Is it possible to use the Like operator as a worksheet-function? Click to expand... Not unless you wrap it in a UDF. See http://www.google.com/groups?selm=uPsppP0d#[email protected]
