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

and so forth...

And drag that formula down column G as far as necessary.

[quoted text clipped - 30 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1

yes..got it..!

thks a lot..Dave..!!

-via135

--
Message posted via http://www.officekb.com