Updated doc: LEN()

[Steve]

Rewritten and examples added. Not much to it, so suggestions for further examples for using LEN() welcome.

help.appsheet.com

LEN()

Number of characters in textual value

[MultiTech]

IF(LEN([Item_Description]) > 35,
LEFT([Item_Description], 35) & “…”
[Item_Description]
)

If the description of the item is longer than 35 characters, only the first 35 are shown and an ellipsis is added to show more text has been cut off; otherwise the full description is shown.

---

This came from an app of mine where I create a summary of a record - part of that means I have to cut down some of the texts that are entered.

[Swoopy]

Are the spaces, like " 123abc ", counted?

Regards,

[MultiTech]

Should be; LEN() counts the characters, and " " is a character.