How to remove Strikeout text in Excel
I have a spreadsheet with strike out text combine with regular text in a cell. How do I remove only the strike out text from the cells? The column
is over 7000 rows and it would be great if I can accomplish this task automatically. Thanks in advance for any help provided.
Re: How to remove Strikeout text in Excel
According to my information this is easy in Excel to remove the Strike out text from the cell, so for that you have to select the entire cells. After selecting the cell you just have to follow these simple steps:
- Format>Cells>Font.
- Uncheck "strikethrough"
May this will help you out to remove the strikeout text
Re: How to remove Strikeout text in Excel
If you wish to make the use of the macros then you just enter this macro. Select the cells you want to clean-up. Run the macro.
Code:
Sub no_strike()
'
' gsnuxx
'
For Each r In Selection
v = r.Value
v_out = ""
For i = 1 To Len(v)
piece = Mid(v, i, 1)
If r.Characters(Start:=i, Length:=1).Font.Strikethrough = False Then
v_out = v_out & piece
End If
Next
r.Value = v_out
Next
End Sub