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!
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!
