Like operator as a worksheet-function
 

Hi

Is it possible to use the Like operator as a worksheet-function?

Tom

Like operator as a worksheet-function
 

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

Like operator as a worksheet-function
 

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

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

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

Like operator as a worksheet-function
 

"Tom" wrote...
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=uP...icros oft.com

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.