How to use Trim to remove unwanted spaces and Concatenate to put entries together

In this two parter - the first part shows you how to use the Trim() function to remove unwanted spaces in Excel text. The second part explores how to combine multiple entries in Excel using: a formula (&), the Concat function and TextJoin