len() count incorrect due to line breaks

[RPA]

We have formulas to check character counts and they're returning with "over character count" for long text that is actually not over character count because they're adding characters for line breaks. Is there a way to adjust the formula to not include line breaks as a character?

For example, this would return 338:

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce ac magna volutpat, pretium arcu non, ullamcorper erat. Donec dictum eros in tellus elementum sollicitudin. Morbi sit amet justo purus. Phasellus interdum eros eu quam euismod, sed efficitur lorem fermentum. Sed neque metus, dapibus at sapien at, pellentesque placerat ipsum.

But the same text with line breaks would return 342 and if the character count formula were set to 340, would show as over cc:

Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Fusce ac magna volutpat, pretium arcu non, ullamcorper erat.
Donec dictum eros in tellus elementum sollicitudin. Morbi sit amet justo purus. Phasellus interdum eros eu quam euismod, sed efficitur lorem fermentum.
Sed neque metus, dapibus at sapien at, pellentesque placerat ipsum.

[Dominic · Accepted solution]

Hi RPA,

If you are using LEN() then you should be able to modify the formula to remove the line breaks. Something like this should work:

LEN(SUBSTITUTE({Text}, "\n", ""))

[RPA]

Thank you! That works perfectly!