Spreadsheet function that mimics "LIKE"
Hi
have a look at FIND and SEARCH
or use
=IF(COUNTIF(A1,"*text_to_search*")0,"found","not found")
--
Regards
Frank Kabel
Frankfurt, Germany
"quartz" schrieb im Newsbeitrag
...
Is there a spreadsheet function that works like "Like" in VBA? I need
to use
a spreadsheet function to identify if a certain pattern exists in a
cell for
example:
###.###.####.######.###.##.###
I know this can be done in VBA, as I myself have used it often. But,
is
there a spreadsheet function equivalent to "Like"?
If so, please post back with it. Thanks much in advance.
|