I have to edit text in a system upload spreadsheet where I'm only allowed 40 characters per line. By using Alt-Enter I can create the multi line entries necessary to conform to this 40 character per line limit.

Does anyone know how I can count the characters on each line within a cell please ? I'm familiar with the LEN(A1) command, but that's all I know.

Any advice or suggestions would be most welcome.

TW