Counting items from a text/number field

Paul Reeves

I have some users where we set up a text field and they are pasting information from Excel into the field. The info is nicely formatted and appears to have carriage returns when I wrap the text, see below. I am wondering if there is a formula that would help me count the number of items in the cell.

Thank you

Paul Newcome

Try something along the lines of

=LEN([Affected Packs]@row - LEN(SUBSTITUTE([Affected Packs]@row, CHAR(10), "")) + 1

Paul Reeves

That did the trick. Thank you very much.

BTW... it was great meeting you @ENGAGE.

Paul Newcome

Try something along the lines of

=LEN([Affected Packs]@row - LEN(SUBSTITUTE([Affected Packs]@row, CHAR(10), "")) + 1

Paul Reeves

That did the trick. Thank you very much.

BTW... it was great meeting you @ENGAGE.

Paul Newcome

Happy to help. 👍️

Likewise!