View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Like operator as a worksheet-function

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