The CONCATENATE function in Excel has never been one of my toolbox - too cumbersome, but the newest version of Excel includes the TEXTJOIN function... like Concatenate but so much more intuitive. Check it out!
What code can I write to combine cells in Excel? on Quora