GateMe Pro

• VR & mixed reality
• Entertainment Entertainment Xbox Game Pass Ultimate PC Game Pass Xbox games PC games Windows digital games Movies & TV
• Xbox Game Pass Ultimate
• Business Business Microsoft Cloud Microsoft Security Dynamics 365 Microsoft 365 for business Microsoft Power Platform Windows 365 Microsoft Industry Small Business
• Microsoft 365 for business
• Developer & IT Developer & IT Azure Developer Center Documentation Microsoft Learn Microsoft Tech Community Azure Marketplace AppSource Visual Studio
• Other Other Microsoft Rewards Free downloads & security Education Virtual workshops and training Gift cards Holiday gifts Licensing Microsoft Experience Center
• Free downloads & security
• Virtual workshops and training
• Microsoft Store & billing
• Report a support scam
• Automatically number rows Article
• Calculate the difference between two dates Article
• Define and use names in formulas Article
• Combine text from two or more cells into one cell Article You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function

Combine data with the Ampersand symbol (&)

• Select the cell where you want to put the combined data
• Type = and select the first cell you want to combine
• Type & and use quotation marks with a space enclosed
• Select the next cell you want to combine and press enter
• An example formula might be =A2&" "&B2

Combine data using the CONCAT function

• Select the cell you want to combine first
• Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text

Select the cell you want to combine first

Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text

• Close the formula with a parenthesis and press Enter
• An example formula might be =CONCAT(A2, " Family")

You can always ask an expert in the Excel Tech Community or get support in the Answers community

Using Flash Fill in Excel Combine data from multiple data sources (Power Query)