|
|
|
|
#1
10-26-2016, 09:21 AM
|
|||
|
|||
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 
|
|
#2
10-26-2016, 09:57 AM
|
||||
|
||||
|
Like this ? =MID(A1,FIND(CHAR(1),SUBSTITUTE(A1,"/",CHAR(1),4))+1,7)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
| Tags |
| date |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Extract a string from a paragraph
|
kirkm | Word VBA | 7 | 09-11-2016 06:13 PM |
|
How to extract a word from an excel string with various lengths
|
keywestsue | Excel | 3 | 09-18-2015 07:32 AM |
| How to extract only numbers from a STRING? | Learner7 | Excel | 3 | 07-02-2013 06:25 AM |
| Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
| Extract from String using Wildcard | whousedmy | Word | 0 | 05-21-2009 01:35 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode