Show/Hide Formatting Symbols

[Typing in OPA]

Microsoft Word has a feature that will reveal formatting symbols which makes
editing easier. The button looks like a backwards 'P'. Does Excel have such a
feature that will reveal formatting symbols such as spaces, tabs, and line
returns?
--Thanks for any help.

 

[Gord Dibben]

Not really.

If you turn off wraptext you will see Tab(char 10) or an incell
linefeed(char 10) character as a square box symbol.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Chip Pearson has a very nice addin that will help determine what those cells
really contain:
http://www.cpearson.com/excel/CellView.aspx