Forum Discussion
Cell Text expanding and not expanding
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?
Detlef_Lewin Actually, I uploaded that file because I don't know how to do a screenshot and I needed to show an example of the problem. Everything I saw in the spreadsheet was saying each line had the same font but it seems that it was spreading the letters on the 2nd and 3rd line after I hit enter.