View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Find position of date in string

Hi Robert,

Am Wed, 9 Oct 2019 03:13:33 -0700 (PDT) schrieb RG III:

What's a good method for finding the position of the first date in a
string? In the above example, it starts at position 25.


try:

Const myStr = "The video shows that on 9/24/2019 the suspect entered the store."

i = InStr(myStr, "/")
myPos = InStrRev(myStr, " ", i) + 1


Regards
Claus B.
--
Windows10
Office 2016