Letters and numbers [Closed]

Report
-
Posts
2700
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 25, 2021
-
Hello,

Could someone please help. Is there a formula to convert A12812001 into 5/8/2015. A =2015 and 128 = the day. The rest of the numbers do not mean anything for what I am doing.

Thank you I greatly appreciate your help.

1 reply

Posts
2700
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 25, 2021
457
Hi Judy,

So if A = 2015, then B is probably 2016 and so on.

We need to create a list for that. So one column contains A, B, C.... and the other 2015, 2016, 2017 and so on.

In the following formula your value is placed in A1 and the list is located in columns K and L:
=DATE(VLOOKUP(LEFT(A1,1),K1:L26,2),1,MID(A1;2;3))

Format the formula cell as date in the desired format.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!