How can I extract date from such strings in excel?
John8/11/12
Jackson09/11/2013
Desired result:
John 8/11/12
Jackson 09/11/2013
Can I do this using only excel formula using excel functions?
How can I extract date from such strings in excel?
Desired result:
Can I do this using only excel formula using excel functions? 

migrated from stackoverflow.com Mar 8 '13 at 4:24This question came from our site for professional and enthusiast programmers. 


To extract name:
To extract date:
Note : both must be entered as an array formula 


Use 


You might want to use regular expressions in order to achieve this. Im not very familiar with excel but heres a link that might help http://www.dzone.com/snippets/regularexpressionsexcel2007 


Excel Function:
Then in your In your worksheet cell: For Name: For Date: 

