Extract year from alphanumeric serial numbers.
Closed
Mike
-
Updated on May 23, 2017 at 07:46 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 25, 2017 at 02:34 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 25, 2017 at 02:34 PM
Related:
- Extract year from alphanumeric serial numbers.
- Nic serial number - Guide
- Idm serial number - Downloads Forum
- Extract audio from video vlc - Guide
- Nero 6 serial number - Software Forum
- Extract audio from messenger - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 23, 2017 at 08:37 AM
May 23, 2017 at 08:37 AM
Mike, Good morning.
Try to use:
=VALUE("20" & MID(A1,3,2))
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Try to use:
=VALUE("20" & MID(A1,3,2))
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
May 24, 2017 at 08:06 AM
May 24, 2017 at 08:06 AM
@Mazzaropi:-
Good day Mazzaropi,
You may be interested in this:-
https://www.mrexcel.com/board/threads/mike.1006589/
There are some ungrateful people out there! Beware!
Cheerio,
vcoolio.
Good day Mazzaropi,
You may be interested in this:-
https://www.mrexcel.com/board/threads/mike.1006589/
There are some ungrateful people out there! Beware!
Cheerio,
vcoolio.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 25, 2017 at 02:34 PM
May 25, 2017 at 02:34 PM
vcoolio, Good afternoon.
Thank you for the warning.
Unfortunately, some are not grateful or polite to people who help them for free.
Not even so we will stop helping those in need because of this type of user.
Have a great day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Thank you for the warning.
Unfortunately, some are not grateful or polite to people who help them for free.
Not even so we will stop helping those in need because of this type of user.
Have a great day.
--
Belo Horizonte, Brasil.
Marcílio Lobão
