View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HD[_2_] HD[_2_] is offline
external usenet poster
 
Posts: 2
Default Need to remove text with strikethrough - Excel 2007

I 'inherited' a large spreadsheet where every cell contains free form
text. A single cell can contain text with strikethroughs and plain
text (no strikethroughs). I need to create some VBA to delete only the
text with strikethroughs and leave the plain text within each cell.
I'm not worried about speed.
Does anyone have any ideas?