Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to remove Strikeout text in Excel

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 08-01-2012
Member
 
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.

Reply With Quote
  #2  
Old 08-01-2012
Member
 
Join Date: Jul 2011
Posts: 429
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
Reply With Quote
  #3  
Old 08-01-2012
Member
 
Join Date: Nov 2010
Posts: 420
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
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to remove Strikeout text in Excel"
Thread Thread Starter Forum Replies Last Post
Can only paste text in Excel 2010 Logikar Windows Software 6 13-04-2012 04:59 PM
Total in Text Box in Pie Chart in Excel GuruT MS Office Support 2 07-02-2012 05:57 PM
My Text are overlapping with other columns in Excel RajiI MS Office Support 4 27-01-2012 07:20 PM
It is possible to get reverse text Microsoft Excel Indudep MS Office Support 4 25-01-2012 06:17 PM
How to find replace text in Excel Chini mao Windows Software 3 07-01-2012 11:44 AM


All times are GMT +5.5. The time now is 07:59 AM.