Thread: Microsoft Excel to extract date from another string
View Single Post
 
Old 10-26-2016, 09:21 AM
Rajeshwar Rajeshwar is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Oct 2016
Posts: 1
Rajeshwar is on a distinguished road
Default Microsoft Excel to extract date from another string
Hi Need help in extracting date with the below values

/test/extractDate/agenda/2016/06/09/href.txt||/test/extractDate/agenda/2016/06/09/abc.txt

I need to extract first occurrence of date and month. From the above i need 2016/06 only.

Thanks in advance
Reply With Quote