We have a text field Goal. I'm trying to create a formula field that captures the first 50 characters of the text and boxes the 50 characters to 5 lines of 10 characters without cutting words in half. I have limited space on the Lightning page banner so I don't want the 50 characters to be elongated and take up too much space. The below formula allows the characters continue to the end of the banner. Makes sense?
