Thread
:
date & month
View Single Post
#
1
Posted to microsoft.public.excel.misc
Aditya
external usenet poster
Posts: 54
date & month
In cell A1, data is of 19 or 20 or 21 digit whose last 6 digit is in form of
ddmmyy.
how can i get date and month r in cell A2 & A3 from this.
e.g. A1 A2
A3
NW/RON/ENT/05/010209 01 FEB 09 FEB
NW/SR-B/ENT/04/030509 03 MAY 09 MAY
Reply With Quote
Aditya
View Public Profile
Find all posts by Aditya