Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Suppose you want to create a grammatically correct sentence from several columns of data for a mass mailing or format dates with text without affecting formulas that use those dates. To combine text with a date or time, use the TEXT function and the & (ampersand) operator.

Example

Examples to show how formulas can combine text with date and time values

The TEXT function requires two arguments (that is, items between its parentheses). The first argument is a value, such as a date or a number. This value is converted to a text value. The second argument, format_text, is a special string that Excel recognizes and uses to display the converted text value in a format that you specify. In the second and third examples, the dates in B3 and B4 are converted to text and then is displayed in two different formats: “d-mmm-yyyy” (resulting in June 4, 2010) and “mmmm d, yyyy.” (resulting in Jun-07- 2010).

TEXT function

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×