Wildcards

  • Thread starter Thread starter Guest
  • Start date Start date
anonymous,

Please at least post with a first name. It makes it seem more personal.
(It doesn't have to be your real name either)

For a formula solution, try this:
Type the text "Wildcard" into A1

=IF(ISERROR(SEARCH("*ldca*",A1)),"NG","OK")

If you're looking for a VBA solution, this might work for you.
By nature of the way the INSTR function works, it'll check
for the presence of one string within another. There is no
"wildcard", per se, but if the string that you're looking for
appears within the searched string, it'll give you the position
of where the match was found (which will always be greater
than zero.

Sub TestMe()
If (InStr(1, Range("A1"), "ildca")) > 0 Then
MsgBox "Match"
Else
MsgBox "No Match"
End If
End Sub

John
 
If you mean in VBA, probably not, but
Look at VBA help for LIKE, INSTR, MID, LEFT, RIGHT
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find/Replace MSWord wildcard characters from within Excel 6
Excel Wildcard in Excel array formula 0
Wildcard in Excel for Mac to open ALL files 3
Wildcard in change event ?? 5
Count cells containing text, multiple criteria 2
wildcard 6
sumif wildcard for text and numbers 2
Find Command 9

Back
Top