Is there a way to show Line Break symbol and other hidden characters in a cell similar to how Word does?
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 RangeFor Each rngCell In SelectionIf InStr(rngCell.Text, vbLf) > 0 ThenrngCell.Interior.ColorIndex = 3End IfNext rngCellEnd Sub
@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)
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.