date & month
Hi
I am assuming that you really mean you want the Date in B1 and the Month in
C1.
In B1 enter
=RIGHT(A1,6)
Copy down as far as required
Copy column BPaste SpecialValues
Select column BDataText to ColumnsNextNextDateD/M/YFinish
In cell C1
=TEXT(B1,"mmm")
Copy down as required
--
Regards
Roger Govier
"aditya" wrote in message
...
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
|