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!
Help Article Resources
Check out the Formula Handbook template!