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