How to get only Strikethough Data

[niladri20052006]

Hi All,

Is there any way to get the data which is marked by "Strkethrough".

I have 2,000+ data in a sheet and some rows are marked "Strkethrough" by my client. there are 500+ bold marked rows which I need to move in another sheet.

How do I do that? will I have to do it one by one?

Please suggest!!

 

[Oeldere]

If the text is always in the same collumn you can use a filter to do that for you.

Excel 2007 => data => filter