ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 289
- Office Version
- 365
- Platform
- Windows
Sirs, i have values inputed in a cell combination of number (year), word, letter and other character. If its possible to extract the number and determine the recent year from the extracted number..
Many Thanks,
RESULT | |
2019 text 2022 | 2022 |
2011, text, 2018 | 2018 |
2019, (AC), 2020 | 2020 |
Many Thanks,