Question: how to create a formula in excel for text?
Answer: Select the cell in which you want the combined data.
Type the formula, with text inside double quotes. For example: ="Due in " & A3 & " days" NOTE: To separate the text strings from the numbers, end or begin the text string with a space.
Press Enter to complete the formula.