I have a sku code where the last 4 numbers signify the start date of an event and need to extract this and show as a date.
For example, LONTOR120623. The start date is 12 june 2023.
I know RIGHT(cell,4) will extract the numbers, but i cant get excel to then recognise that as 06-23, not the year 623.
Any help hugely appreciated!
Bookmarks