Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.

The CONCATENATE function is a text function in Excel that allows you to combine more than two strings together into one string. CONCATENATE is a quick and easy way to combine data in Excel.

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

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

Microsoft is testing out a new =COPILOT function in Excel cells – it's in beta with improvements needed, but you can try it now.

When discussing Excel-based reports or data analysis in meetings, I can take notes directly in OneNote and link them to the relevant Excel files.