Thread: Like Character?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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