Using wildcards with the "Like" command

T

Tim Patton

Help !

I want to check values in a column to see if the match a
certain value. I want to use a wildcard to save lines but
I am not sure how the "like" command works.

Can anybody help ?

Cheers and thanks

Tim
 
C

Chip Pearson

Tim,

Try something like

If Range("A1").Value Like "ABC*" Then

This will match any string beginning with the letters "ABC".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

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

Repeated phrases wildcard? 1
Wildcards in SumIF formula 1
Excel formula to count the number of records which contains a certaintext (wildcard) 3
sumif wildcard for text and numbers 5
Macro for intelligent wildcard pattern modification 3
Wildcard operators to use with LIKE 4
With Sheets("wildcard") 4
Wildcard Filtering on ADO Recordset 1

Top