Letters and numbers
Closed
judy
-
May 13, 2015 at 02:42 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - May 19, 2015 at 11:44 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - May 19, 2015 at 11:44 AM
Related:
- Letters and numbers
- Keyboard won't type letters - Guide
- Keyboard typing numbers instead of letters - Guide
- Capital letters with accents - Guide
- Why is my keyboard not typing letters but opening shortcuts - Guide
- Keyboard typing wrong letters ✓ - Keyboard Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
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
