If A1 contains "November 2005" where the '2005' is BOLD and RED, how can I
put a formula in B5 something like "=A1" so that not only the value being
taken but also the BOLD and the RED format?
Thanks a Lot. SUNAN.