Hi All,

Is there a Text function which will trim off accidently entered Carriage Returns at the end of a word or line of text, similar to the Trimming of leading and trailing spaces?

Thanks very much and sorry if it's obvious.

Best regards
David

Sure. I use this to remove the last return...

Case(Right(Text; 1) = "¶"; Left(Text; Length(Text) - 1) ) ; Text )

...and Andrew Parson's custom function to remove returns in between things (like extra returns in a return delimited list).

Thank you John, as always!

Best regards

David