How to Keep HTML after Using Left Function to Produce Excerpt?

Question

I use the Left function in a Rich Text Formula field to show the first 200 characters of a regular Rich Text field. However, in a report, this appears to strip it of its HTML function, showing the source code instead.

e.g. Hello become <a href="google.com">Hello</a>

Is there a way for me to avoid this, and preserve the HTML functionality?

AdeebAlgadban · Answer

You probably truncated a few HTML elements. Ensure you are only truncating on the Text part, not the entire formula contents.

Sign up

Login to the community