Show non-printable characters in EXCEL
Eurlzoo
-
eurlzoo -
eurlzoo -
Hello,
I would like to display the carriage return in my formulas, the little square, but I can't manage to do it. It seems to me that it used to happen automatically if "wrap text" was not checked, but I can't get it back.
I'm using Excel 2007.
Thank you in advance.
Configuration: Windows 7 / Internet Explorer 8.0
I would like to display the carriage return in my formulas, the little square, but I can't manage to do it. It seems to me that it used to happen automatically if "wrap text" was not checked, but I can't get it back.
I'm using Excel 2007.
Thank you in advance.
Configuration: Windows 7 / Internet Explorer 8.0
3 answers
Indeed, that's the problem; it's present but not displaying.
I can verify it by checking "automatic line break" because the text does return to the line where I used "ALT ENTER," but when I uncheck it, the text is just glued together like a CONCATENATE without little squares in between to symbolize the line break.
I can verify it by checking "automatic line break" because the text does return to the line where I used "ALT ENTER," but when I uncheck it, the text is just glued together like a CONCATENATE without little squares in between to symbolize the line break.