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
