Remove spaces from text string

GGarner

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!

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!

GGarner

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.

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