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.
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.
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?
