Try CONCATENATE text1 text2 ie.

Text and formula in excel same cell. Follow these steps to create the formula. Formula explained for real this time Accidently hit enter in the first post. To combine a text string with a formatted date use the Excel TEXT function to format the date.

Joining the contents of cells A2 and B2 would look like this. The formula converts numbers to text. Finally press ENTER to get the result out if you need drag the fill handle over range to apply the formula.

This formula combines text cell references text and numbers and displays it as a string. A2 B2 is C2 years old You can run this formula to multiple examples to see how it works. By suren Tue Nov 18 2014 225 pm.

One way to give yourself some flexibility with formatting is to combine text and the results of a formula in a single cell. I am trying to combine the below two formulas in one cell but no luck so farBoth formulas work OK on their own but I can not figure out how to combine them together to produce the result in same cell. IF AND C180 C6J11 J11 C6 IF AND C17J10 J10 C6 microsoft-excel worksheet-function spreadsheet.

Type the formula with text inside double quotes and the date inside the TEXT function. The formula converts numbers to text. Select the cell where you want the combined data.

Try playing with the. To combine text with numbers inside a formula you can use the ampersand operator. CONCATENATE The total sum is.