Forum Discussion
Cell Text expanding and not expanding
tgivens What do you mean by "it expands"? Can you upload a screenshot, please?
Riny_van_Eekelen One line stays exactly as you type it. On the next line, once you hit enter, the text spreads out to the right, out of the bound of the cell if there's enough text. The sentence "expands" beyond what was originally typed.
- SergeiBaklanJun 22, 2020Diamond Contributor
- tgivensJun 22, 2020Copper Contributor
SergeiBaklan No, it's different. I have attempted to attach a file which shows a sheet illustrating the problem. The first line is exactly how I saw it when I typed it. The second and third lines show how the line "expanded". And I can't find any difference in the formatting of the 3 lines, yet lines 2+3 added space between letters.
- Detlef_LewinJun 22, 2020Silver Contributor
I don't see extra spaces. Like SergeiBaklan suggested it's a different font. In this case a monospaced font (each character has the same width).
If you get the length of each cell it should be same.
=LEN(A1)
=LEN(A2)
=LEN(A3)
Why didn't you upload the xlsx-file?