Get instant live expert help on I need help with strikethrough text generator
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
On Google Sheets, transfer over names in a column that doesn't strikethrough text and alphabetizes them onto a new sheet.
Solved by V. U. in 30 mins
I have a number generator (randbetween(1,69)) that will generate a table of 5 numbers. I am trying to eliminate previous number rows from the generator.
Solved by Z. Y. in 18 mins
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
Solved by D. D. in 16 mins
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
Solved by D. Q. in 23 mins
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.
Solved by E. E. in 14 mins