Does Smartsheet have an equivalent formula to Excel's TRIM to remove spaces in a cell?

Eric_Littauer

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

J. Craig Williams

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