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
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Unicode text and carriage returns 4
Set max characters in cell (Excel 2007) 4
Strange characters in Excel 2

Top