Announcements
I have a simple text label that uses a dynamic value that can vary greatly. I have a finite number of characters I'd like to display and if it exceeds n characters, I want to truncate it so there is no overflow to a 2nd line and I dont want a scrollbar either. How do I perform a simple text truncate?
@Anonymous
I think you could simply use the LEFT function.
Example:
Suppose we have a text string like this
"ABCDEFGHIJKLMNOP"
If you want to truncate after 5 characters do this
Left("ABCDEFGHIJKLMNOP",5)
The result is
"ABCDE"
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Thank you @mdevaney - I knew there would be a simpe fix!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 356 Most Valuable Professional
11manish 225 Super User 2026 Season 2
Mohsin Ali 211