How one can select and copy only the text with the chosen format ?

hi
the copy command pretty much copies everything but the paste command has a
number of options available.
in your case i'm guessing that you want to paste special values. this would
paste only the text and leave the previouse cell's formating behind.

regards
FSt1

"Sir" wrote:

How one can select and copy only the text with the chosen format ?

How to select all the text with certain font (bold, italic and so on) in the
all cells ?

Find, Options, Format

Sir wrote:

How to select all the text with certain font (bold, italic and so on) in the
all cells ?

If all text in the cell is a certain format see Bob's second reply.

If a mixture, you would need VBA


Gord Dibben MS Excel MVP

On Tue, 2 Dec 2008 07:07:02 -0800, Sir
wrote:

How to select all the text with certain font (bold, italic and so on) in the
all cells ?

Dear Bob.
Thank you for your answer:
Find, Options, Format
It's very helpfull.
But you can get them one by one (one at a time).
I would like to select all at once to copy them and paste in the another
sheet. There are many information, so selecting one at a time will take so
much time, that is not desirable method.
How to select all the text with certain font (bold, italic and so on) in the
all cells at once ?

Thank you.