Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

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

Options
Eric_Littauer
edited 12/09/19 in Archived 2017 Posts

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

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 12/03/17
    Options

    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

This discussion has been closed.