Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Does Smartsheet have an equivalent formula to Excel's TRIM to remove spaces in a cell?
Don't know if it's pilot error, a new feature request, or if there's a work around.
Thanks!
Eric
This might get you want you are looking for:
=SUBSTITUTE([TextColumn]23, " ", " ")
for row 23, column named TextColumn.
There are two spaces in the second argument, only one in the third. The fourth argument is optional and here it is omitted -- so the SUBSTITUTE() becomes a global substitute.
Smartsheet already trims trailing spaces. And it also displays as if the spaces were already trimmed.
I hope this helps.
Craig
