Extracting date from a series of numbers

Solved/Closed
seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 - Feb 9, 2010 at 06:11 AM
 Santos - Jul 14, 2010 at 01:51 AM
Hello,

I need to extract "date" exsiting in a specific space in a series of numbers and get it in another cell. I don't want to split the series using 'text to column" and then pick up the date.

Example:

Data (Column A)
20100103001
20100203555
20100304668
20100201365
20100201568

Where: space 1 to 4 indicate year, space 5 to 6 indicate month, space 7 to 8 indicate date and space 9 to 12 is any sequence number and doesn't needed in Answer column B and is ignoreable.

The Required Column B should be as follow:

Column B
03-Jan-2010
03-Feb-2010
04-Mar-2010
01-Feb-2010
01-Feb-2010

Thanks......seekermay

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2010 at 09:01 AM
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
Format it to the way you want as this is a date to excel and not some thing that looks like a date
0
really nice to solve to prob.
0
seekermay Posts 28 Registration date Wednesday January 27, 2010 Status Member Last seen May 27, 2013 5
Feb 9, 2010 at 01:56 PM
thanks! It works.
0