![]() |
#4
|
|||
|
|||
![]()
Graham, been playing around with your routine and not having any luck with a line I've changed:
Do While .Execute(FindText:="^p" & "010" & "^t", MatchWildcards:=False) It finds nothing, even though the text does exist. If I change MatchWildcards to True it reports error 5692 but no description just one little square shape. I googled for that error but found no definite reason (except perhaps it's the ^ char.) Obviously I'm doing something wrong... can you see what it is? Possibly that syntax is for RegEx only? Something else is for finding a text match ? Thanks. |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
keywestsue | Excel | 3 | 09-18-2015 07:32 AM |
How to extract only numbers from a STRING? | Learner7 | Excel | 3 | 07-02-2013 06:25 AM |
![]() |
OTPM | Excel | 6 | 05-13-2011 12:52 AM |
Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
Extract from String using Wildcard | whousedmy | Word | 0 | 05-21-2009 01:35 AM |