Fresh Excel Tips

For this example, we are going to combine text and numbers from two different cells into one cell. To achieve this, we will need to use the & Operator. This will basically combine the different cell values that we will be working with. Here is how to do it.

How to combine text and numbers in Excel

1. Open Microsoft Excel
2. Select B1 and type miles
3. Select B2 and type 8
4. Select B4 and type the following formula: =”You ran “& B2 & ” ” & B1 & ” today!”.

Each cell reference must be placed between & operators, and additional text must be surrounded by quotation marks.

How to Combine Text and Date

1. Select cell A1 and type Date of Concert.
2. Select cell C1 and type the following formula: TODAY().
3. Select cell A3 and type the following formula: =A1& ” “&TEXT(C1,”MM/DD/YYYY”).

How to Combine Text and Time

1. Select A1 and type Flight.
2. Select D1 and press CTRL+Shift to insert the current time.
3. Select A5 and type the following formula: =” Next “& A1 & ” at ” & TEXT(D1,”hh:mm PM”).

That should cover everything!

1. How to Combine Parts of Date using the DATE Function in Excel
2. How to Use the TEXT Function to format and combine text
3. How to use the TEXT function to extract parts of a date in Excel
4. Using the OR function to check cells for text or numbers in Excel
5. How to add months to a date using the DATE Function in Excel