Results 1 to 3 of 3

Thread: How to remove Strikeout text in Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    64

    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.

  2. #2
    Join Date
    Jul 2011
    Posts
    441

    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

  3. #3
    Join Date
    Nov 2010
    Posts
    423

    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

Similar Threads

  1. Can only paste text in Excel 2010
    By Logikar in forum Windows Software
    Replies: 6
    Last Post: 13-04-2012, 03:59 PM
  2. Total in Text Box in Pie Chart in Excel
    By GuruT in forum MS Office Support
    Replies: 2
    Last Post: 07-02-2012, 04:57 PM
  3. My Text are overlapping with other columns in Excel
    By RajiI in forum MS Office Support
    Replies: 4
    Last Post: 27-01-2012, 06:20 PM
  4. It is possible to get reverse text Microsoft Excel
    By Indudep in forum MS Office Support
    Replies: 4
    Last Post: 25-01-2012, 05:17 PM
  5. How to find replace text in Excel
    By Chini mao in forum Windows Software
    Replies: 3
    Last Post: 07-01-2012, 10:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •