You can combine text from multiple cells into one cell in Excel using the Ampersand symbol (&) or by using the CONCATENATE function.

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.

Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.