Excel for Beginners: Easy Steps to Get Started - Combine Text and Numbers into One Cell in Excel

In this Microsoft Excel lesson, I will show you how to combine text and numbers in different cells into one cell and keep the number formatting. Using the ampersand(&) in Microsoft Excel allows you easily combine cells into one. Using the TEXT function with custom formatting in the equation allows you to add formatting to the number. 0:00 Intro 0:36 Combining cells using the ampersand sign in Microsoft Excel 1:15 Adding spaces, symbols, or more text to the combined data 3:36 Coping number format into TEXT function 5:35 Customizing number format by adding text 8:05 Copy the number format from another cell into your TEXT function More ways to combine cells in Microsoft Excel: https://youtu.be/fgFzb5b7GlU Different ways to split cells in Microsoft Excel: https://youtu.be/nm9z1AdudCM