Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Use Excel Text Function in Microsoft Excel?

Date:2021-6-4 Author:Sandra

The TEXT function is one of the very frequently used functions, it can be used as a worksheet function in Excel. You can use the TEXT function to embed formatted numbers inside text.

Syntax 

=TEXT (value, format text)

Value: Value you want to format

Format text: Format code you want to apply

Now, Let’s learn the common usage of TEXT function together through a few simple examples.

Example 1: Simple Employee Appraisal

The table below shows part of the staff appraisal form of a certain unit. It needs to be evaluated based on the assessment scores. A score of 85 or more is A, a score of 76 to 85 is B, and a score of 75 or less is C.

How to Use Excel Text Function in Microsoft Excel?

Enter =TEXT(D2,”[>=85] A; [>=75]B;C”) in cell E2, and Drop-down fill it.

How to Use Excel Text Function in Microsoft Excel?
How to Use Excel Text Function in Microsoft Excel?

Example 2: Combine Formatted Content

Enter =A2&TEXT(B2,””) in cell C2.

How to Use Excel Text Function in Microsoft Excel?
How to Use Excel Text Function in Microsoft Excel?

Example 3: Calculation Interval Hour

Enter =TEXT(B2-B1,”[h]”) in cell B3.

How to Use Excel Text Function in Microsoft Excel?
How to Use Excel Text Function in Microsoft Excel?

After reading the above examples, did you find that the Text function is also very powerful and practical?  Have you got it?

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *