| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Like Character?
"Bernie Deitrick" <deitbe @ consumer dot org wrote in Also, I'm getting the feeling that the LIKE operator doesn't like #'s but only likes *'s and ?'s. Actually, it does like #'s, just not my bone-headed use of them. If you have This BBB-CCC-DDDD 555-123-4578 ext 146 then =myFind(A1, " ???-???-????","") returns "BBB-CCC-DDDD" while =myFind(A1, " ###-###-####","") returns 555-123-4578 Bernie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
| Custom Character or re-defining a character | Excel Programming | |||
| Typing a quote character Vs pasting a quote character= whathappens to the resulting CSV? Interesting!! | Excel Programming | |||
Hybrid Mode
