Selecting needed format
 

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

Selecting needed 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 ?

Selecting needed format
 

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

Selecting needed format
 

Find, Options, Format

Sir wrote:

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

Selecting needed format
 

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 ?

Selecting needed format
 

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 ?

Selecting needed format
 

Thank you.