How to extract Date in a string [Closed]

Registration date
Thursday January 30, 2014
Last seen
January 30, 2014
 Blocked Profile -
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

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!