Show special characters/symbols for carriage returns and line feeds

tttmack

New Member
Joined
Dec 17, 2014
Messages
16
I'd like to know if there is some special way that we can visualize carriage returns, line feeds and other whitespace(like tabs) within cell text similar to what you can see on this screenshot of Notepad++: http://i.stack.imgur.com/ocDNf.jpg

I'd like to either achieve this by changing to a font (if there is one) that displays these special characters instead of whitespace or by replacing text in the cells so that they show the special characters instead of the whitespace.

Note that I'd like to display special characters if replacing text, not their programming escape codes like '\r' or '\n'. Ideally, I'd want this in C# for VSTO, but if someone knows how to do it in VBA that would also be greatly appreciated.

thanks in advance!
 

Forum statistics

Threads
1,082,551
Messages
5,366,268
Members
400,881
Latest member
DevelopedUnkown

Some videos you may like

This Week's Hot Topics

Top