For a version of this tip written specifically for earlier versions of Excel, click here: Updating Links. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you.Combine text, numbers, dates and more from multiple cells into one. =CONCATENATE is one of the easiest to learn but most powerful formulas when conducting data analysis. If you're just starting your Data Analysis in Excel journey then this is a great place to start.