Thread: Finding substrings within a string
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
acw[_2_] acw[_2_] is offline
external usenet poster
  
Posts: 100
Default Finding substrings within a string
H

Try
str1 = "ABc
str2 = "AAA AAB AAC ABC ABC

MsgBox InStr(1, str2, str1, 1

Ton

----- Gaston wrote: ----

Sorry if this question seems trivial, but for the life of me, I can'
figure out how to search for something within a string

Say I got str1="ABC" and str2="AAA AAB AAC ABC ABC
I want to be able to search str2 and see if str1 exists within it.

Thanks in advanced


--
Message posted from http://www.ExcelForum.com


Reply With QuoteReply With Quote