Display or hide control characters in Excel 2007

S

schackbo

In Excel 2007, how can I display or hide control characters? I can't find
that option. I want to be able to see control characters in my spreadsheets
(i.e. carriage returns, etc.).
Thanks
 
G

Gord Dibben

Excel has very limited capabilities as a word processor.

If you have linefeeds in a cell, disabling "wrap text" will show the
linefeeds as small squares.

Other than that...............I know nothing<g>


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show or Hide control characters in a cell (using Excel 2007)... 0
Is there an option to view Special (control) Characters in Excel 2 3
How can I display control characters in Excel 2007? 1
Viewing Control Characters 3
Find text in cell and copy from 4 characters in front of the found text. 2
Printing Outline view - formatting lost 0
Slideshow with black border around it 0
WORD VBA Search and switch to advanced ... 1

Top