| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using wildcards with the "Like" command
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using wildcards with the "Like" command
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 "Tim Patton" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search for text "beginning with" "containing" wildcards | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Need command line to change "#DIV/0!" into a "0" (zero) | Excel Discussion (Misc queries) | |||
| Excel custom autofilter- how to find wildcard characters but not as wildcards (e.g. "?") in a cell | Excel Discussion (Misc queries) | |||
| inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions | |||
Linear Mode
