How to copy format from the cell which is having different format

[Het]

If we are having two diffrent format text in one cell.

e.g. Hetal(JAN 09)
Pratik(JAN 09)(Here. JAN 09 in bold and red font)

Now if i want to copy same format in first cell, i.e. I want bold and red
font for JAN 09 .I want this format only for JAN 09.

Now if i am having thousands of cells having JAN 09 unbold.and i want to
change them by bold letters and red fornt.Then which is the easy way to copy
format?

[Paul Herber]

Post by Het
If we are having two diffrent format text in one cell.
e.g. Hetal(JAN 09)
Pratik(JAN 09)(Here. JAN 09 in bold and red font)
Now if i want to copy same format in first cell, i.e. I want bold and red
font for JAN 09 .I want this format only for JAN 09.
Now if i am having thousands of cells having JAN 09 unbold.and i want to
change them by bold letters and red fornt.Then which is the easy way to copy
format?

I suspect you want the Excel groups which is over there ==>
This one is for Visio.