Letters and numbers
Closed
judy
-
May 13, 2015 at 02:42 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 19, 2015 at 11:44 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 19, 2015 at 11:44 AM
Related:
- Letters and numbers
- Keyboard won't type letters - Guide
- Keyboard letters not working but numbers are - Guide
- Why is my keyboard not typing letters but opening shortcuts - Guide
- Capital letters with accents - Guide
- 1,000 business letters pdf free download - Download - Other
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 19, 2015 at 11:44 AM
May 19, 2015 at 11:44 AM
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
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
