How to extract Date in a string

Eravon Posts 3 Registration date Thursday January 30, 2014 Status Member Last seen January 30, 2014 - Jan 30, 2014 at 05:44 AM
 Blocked Profile - Jan 30, 2014 at 10:36 AM
Dear Friends,

I need your help in extracting data in a string.

Example : Student name , Class, section, DOB, Address, email ID.

Sachin Nabar, Bcom, A, 3-May-87, Jaynagar, Bangalore,
Ravi Balu Mule, BA, 20-Dec-90, 2phase, Maruthi nagar,

Kindly Do needful.

Thanks & Regards,

p.s. email address altered by moderator for security reasons.

1 reply

Blocked Profile
Jan 30, 2014 at 10:36 AM
Ok, you can use the built in function on the tol bar of "text to columns". Look at the example below. If you have any questions, let us know.