May 24 2019 10:45 AM
Is there a way to show Line Break symbol and other hidden characters in a cell similar to how Word does?
May 24 2019 10:58 AM
Hi,
ok i didn't know such a function, but the following macro color all cells in selection with Line breaks.
Sub ColorLineBreak()
Dim rngCell As Range
For Each rngCell In Selection
If InStr(rngCell.Text, vbLf) > 0 Then
rngCell.Interior.ColorIndex = 3
End If
Next rngCell
End Sub
Best regards
Bernd
May 24 2019 10:58 AM
@anthonyjb , nope, not such way.
As workaround you may apply conditional formatting to highlight entire cell with non-printable characters with the rule like =A1<>CLEAN(A1)
May 24 2019 06:51 PM
Thanks for the suggestions. Microsoft needs to make that an option like do in Word instead of me writing custom formulas to find these hidden items.