snickerbe3
03-11-2016, 02:25 PM
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 strikethrough formatting applied. I want to identify all records with any strikethrough format applied, whether to one cell in the row or all cells in the row. My end goal is to separate any row with strikethrough 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 strikethrough formatting applied. I want to identify all records with any strikethrough format applied, whether to one cell in the row or all cells in the row. My end goal is to separate any row with strikethrough 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!!