Hi,

Select the destination cell right click /paste special/ format.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.


"Sir" wrote:

How one can select and copy only the certain format text ?