Remove spaces from text string

In a column that I've titled File Name, I've created a =JOIN formula that merges multiple columns of information to generate a consistent set of file names. One of the columns that is being merged shows the title of an item with spaces between words (e.g., in the Title column, one of the titles reads: Curriculum Introduction). Would it be possible to remove spaces from this text string, so that the phrase reads CurriculumIntroduction instead? I've created a secondary column called 'Title Joined' to display the Title column phrases with no spaces... just not sure what the formula should be. Thank you for considering!

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @GGarner

    I hope you're well and safe!

    If you remove the JOIN formula's delimiter, it should work.

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • GGarner
    GGarner
    edited 11/07/22

    Thanks so much for your reply!

    The JOIN formula reads as follows: =JOIN([Subject ID]@row:Title@row)

    Assuming I correctly interpret the meaning of delimiter 😊, I included the delimiter "." originally to ensure there is a period between Subject ID and Title, but if needed, I can work around that by adding a period to the Subject ID selections.

    Removing the delimiter does not resolve the issue of eliminating spaces between words in the Title column.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @GGarner

    What about using the SUBSTITUTE Function?

    =SUBSTITUTE(Title@row, " ", "")

    Then you can join this helper column cell instead of the Title cell!

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!