HDTutorial
EN
How to Delete Strikethrough Text in MS Excel in 1 second !!!!

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Delete Strikethrough Text in MS Excel in 1 second !!!!

6,100 views November 14, 2017 2:39

Watch on YouTube
ChannelShobhit Jain

Description from the creator

Visual Basic Code

Sub DelStrikethroughText()
'Deletes strikethrough text in all selected cells
Dim Cell As Range
For Each Cell In Selection
DelStrikethroughs Cell
Next Cell
End Sub

Sub DelStrikethroughs(Cell As Range)
'deletes all strikethrough text in the Cell
Dim NewText As String
Dim iCh As Integer
For iCh = 1 To Len(Cell)
With Cell.Characters(iCh, 1)
If .Font.Strikethrough = False Then
NewText = NewText & .Text
End If
End With
Next iCh
Cell.Value = NewText
Cell.Characters.Font.Strikethrough = False
End Sub

About this tutorial

Shobhit Jain published this 2:39 video tutorial on November 14, 2017. It has been watched 6,100 times on YouTube.

Duration
2:39
Published
November 14, 2017
Views
6,100
Likes
51

Tags

Share

This tutorial in other languages