New Line Break within a cell

[anthonyjb]

Is there a way to show Line Break symbol and other hidden characters in a cell similar to how Word does?

[#2]

@anthonyjb 

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

www.vba-Tanker.com

[#3]

@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)

[#4]

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.