=SUBSTITUTE(TRIM(IF(B2<"","",text($B$1,mmm-yy"))&" "
&IF(C2<"","",text($C$1,mmm-yy")&" "

and so forth...

"via135 via OfficeKB.com" wrote:

Dave Peterson wrote:
And drag that formula down column G as far as necessary.

I would insert another column (use a header of All) and then put this formula in
H2 (your data went to column G):
[quoted text clipped - 36 lines]

Dave Peterson


stupendous..Dave..!

this is what i exactly wanted..!
but..a small hitch..!
i'm getting the values in Col H as under..!

39881--39912
39822--39912--39942
39881--39973

39822--39853--39881
39853--39912
39822--39853--39912--39942--39973
39822
39881--39912
39973
39822--39853--39881--39912--39942--39973

how can i convert them into "mmm-yy" format within the single cell..!
hlp me to fix it..!

-via135

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1

--

Dave Peterson