Inside of using the CONCAT function or writing a formula joining cells together with the & symbol, try using Ctrl + E.

Insert the pattern you want Excel to use from your data, and then press [Ctrl + E]