Text Function in Excel

 In Uncategorized

What is the Text Function in Excel?

The Text function in Excel returns a number in a specified number format, as text. You can use the Text function to embed formatted numbers inside the text. Let me give you an example.

How to Use Text Function?

In the given example below, we need to write “GP is $100” using TEXT function. As a result, if GP changes to $500 (as an example), then we just change the number in cell C2, and it will be automatically changed in C4, where the Text function will be used.
hot keys text function

  • Put a ‘=‘ sign in the cell C4 and reference the cell B2, where “GP” is written.

hot keys text function

  • Connect the cell references and the text with ‘&’.

hot keys text function

  • You need to type the text in the parenthesis. In our example, we want to write “GP is $100”, so the text in parenthesis will be “ is ”. Notice, that we need the space before and after “is”, otherwise it will be all together (like “GPis$100”, which we don’t want to happen).

hot keys text function

  • Link the cell references and the text with ‘&’.

hot keys text function

  • Let’s use the TEXT function for the cell C2, so if the number in C2 will change, it will also automatically change in our text.

hot keys text function

  • Create a reference the cell C2 within the TEXT function.

hot keys text function

  • Put a reference the cell C2 within the TEXT function

hot keys text function

  • After referencing the cell with the number we need in our text, we need to put the format as we want it to appear in our text, as it shown on the picture below.

hot keys text function

  • Click “Enter” after you finish writing the formula.

Now the text in the cell C4 is flexible. Therefore, if we change the values in the referenced cells (in the cell C2 in our example), the text will change as well.
You can see in the pictures below, that when we have changed the value in the cell C2 from “$100” to “$500”, it has changed in our text in C4 as well.
hot keys text function
hot keys text function

Conclusion

The Excel Text Function is used to convert numbers to text within a spreadsheet. Essentially, the function will convert a numeric value into a text string. Text function is available in all versions of Excel. Learn more text function in our next blogs and by playing our Hot Key Excellence Game.

Play Game Now

Recent Posts

Leave a Comment

How can we
help you?
Contact Us

Please, leave a message and we'll get back to you asap

0

Try Excel Game

for FREE