Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a wildcard pattern to find " apt ", the text apt with one space at the
begining and one space at the end. Thanks in advance |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
did you try a "?" ?
-- Gary "LuisE" wrote in message ... I need a wildcard pattern to find " apt ", the text apt with one space at the begining and one space at the end. Thanks in advance |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Gary,
Could you please elaborate? "Gary Keramidas" wrote: did you try a "?" ? -- Gary "LuisE" wrote in message ... I need a wildcard pattern to find " apt ", the text apt with one space at the begining and one space at the end. Thanks in advance |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why would you need a wildcard for this?
I would think you'd just use that " apt " string??? But if you're using Find, then maybe just looking in xlpart would be sufficient. If you're using like, then maybe: "* apt *" would work LuisE wrote: I need a wildcard pattern to find " apt ", the text apt with one space at the begining and one space at the end. Thanks in advance -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for your response Dave, handy as always.
I'm using like, i want to find apt as part of and address text. I was using "* apt *" but i realized that it was case sensitive, I had to use Option Compare Text to make it work. Thanks again "Dave Peterson" wrote: Why would you need a wildcard for this? I would think you'd just use that " apt " string??? But if you're using Find, then maybe just looking in xlpart would be sufficient. If you're using like, then maybe: "* apt *" would work LuisE wrote: I need a wildcard pattern to find " apt ", the text apt with one space at the begining and one space at the end. Thanks in advance -- Dave Peterson |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You could have used:
if lcase(mystr) like lcase("* apt *") then to make sure you're looking at lower case on either side. There's another function that you may want to keep in mind: InStr It has a parm that you can specify to ignore case. dim AptPos as long aptpos = instr(1,mystr," apt ",vbtextcompare) if aptpos = 0 then 'not there else 'starts at aptpos end if LuisE wrote: Thanks for your response Dave, handy as always. I'm using like, i want to find apt as part of and address text. I was using "* apt *" but i realized that it was case sensitive, I had to use Option Compare Text to make it work. Thanks again "Dave Peterson" wrote: Why would you need a wildcard for this? I would think you'd just use that " apt " string??? But if you're using Find, then maybe just looking in xlpart would be sufficient. If you're using like, then maybe: "* apt *" would work LuisE wrote: I need a wildcard pattern to find " apt ", the text apt with one space at the begining and one space at the end. Thanks in advance -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to add a space after each text value in all the cells in a row | Excel Discussion (Misc queries) | |||
Space removal - a first name,space last name | Excel Discussion (Misc queries) | |||
Space in text | Excel Discussion (Misc queries) | |||
formula that will go up one space if no value in specified space | Excel Worksheet Functions | |||
Paper Space / Model Space ? | Excel Discussion (Misc queries) |