Hi,
I have a specific text in cell "A1" as "ABCDEWXYZ19N0411500AB
in above text
(Letter thirteen,fourteen indicate date = 04)
(Letter twelve indicate month = Nov)
(Letter ten,eleven indicate year = 19)
I want to find : if first letter must be "A" and twelve letter must be "N" then
in cell "B1" reply date as "04-Nov-19" otherwise BLANK
Thanks
Bookmarks