Get instant live expert help on how to strikethrough text

On Google Sheets, transfer over names in a column that doesn't strikethrough text and alphabetizes them onto a new sheet.

How do I transfer over words across Google Sheets to another page, but other transfer them when they aren't strikethrough and alphabetize them on the page being transfered to.

I cant get strikethrough off of my excel. I highlighted the words and went to the format column and then format cell and unclicked strikethrough and clicked normal font. it worked but when I clicked on another column it came right back. I need help ASAP

Sub ConcatWithStyles() Dim X As Long, Cell As Range, Text As String, Position As Long Range("A3").Value = Space(Evaluate("SUM(LEN(A1:F1))+COLUMNS(A1:F1)-1")) Position = 1 Application.ScreenUpdating = False For Each Cell In Range("A1:F1") With Range("A3") .Characters(Position, Len(Cell.Value)).Text = Cell.Characters(1, Len(Cell.Value)).Text For X = 1 To Len(Cell.Value) With .Characters(Position + X - 1, 1).Font .Name = Cell.Characters(X, 1).Font.Name .Size = Cell.Characters(X, 1).Font.Size .Color = Cell.Characters(X, 1).Font.Color .Strikethrough = Cell.Characters(X, 1).Font.Strikethrough End Sub

I'm working on an Excel spreadsheet with 7 columns. If there is a DATE in column 5, I'm wanting the whole line formatted with strikethrough. How do I do this under conditional formatting? Or, is there another way?