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!

PDunn

@Paul Newcome

I would like to count number of lines of text in a cell. There are hard returns in the information. Is this possible with this same formula shown above? I am getting invalid operation

=LEN(Bullets@row - LEN(SUBSTITUTE(Bullets@row, CHAR(10), "")) + 1)

number of bullets in a cell 7.18.24.jpg

Paul Newcome

@PDunn Yes. There is just a misplaced parenthesis (my fault).

=LEN(Bullets@row) - LEN(SUBSTITUTE(Bullets@row, CHAR(10), "")) + 1

PDunn

@Paul Newcome perfecto it worked thanks for the clarification.

Paul Newcome

Happy to help. 👍️