snickerbe3
New Member
- Joined
- Apr 26, 2004
- Messages
- 7
Hello,
I am using Excel 2010. I have a file with data in columns A to AB and about 15,000 rows of data. Any one or more cells per row may have strike-through formatting applied. I want to identify all records with any strike-through format applied, whether to one cell in the row or all cells in the row. My end goal is to separate any row with strike-through formatting to move these rows to a different worksheet. Any advice on how to accomplish this will be greatly appreciated!
Thank you in advance for your time!!
I am using Excel 2010. I have a file with data in columns A to AB and about 15,000 rows of data. Any one or more cells per row may have strike-through formatting applied. I want to identify all records with any strike-through format applied, whether to one cell in the row or all cells in the row. My end goal is to separate any row with strike-through formatting to move these rows to a different worksheet. Any advice on how to accomplish this will be greatly appreciated!
Thank you in advance for your time!!