Thread: substring check
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Net Doe Net Doe is offline
external usenet poster
  
Posts: 10
Default substring check
In VBA, how can I check if a substring exists in a cell? Say
cells have
ABC123
D123EF
GHI456

How can I test if a cell has "123" in it, in this case, the top 2 cells
will pass the test.


Reply With QuoteReply With Quote