# How to Use TO TEXT Function in Google Sheets

The TO_TEXT function in Google Sheets turns a number into a text.

The function helps you easily convert a series of a specific set of numbers into a text.

Here are the things that you should keep in mind when working with the `TO_TEXT` function:

• The function has only one argument, the value.
• The argument can be written as the actual value or reference cell.

Let’s check the example below.

A Secretary needs to input all the employees’ data into the system. However, their system only accepts a text format. This means that she needs to type the employees’ date of birth manually.

 Employee’s Name Date of Birth Result Marjorie 09/29/1978 Karen 07/29/1988 Jessica 06/24/1990 Johnson 10/14/1975

The Secretary utilizes Google Sheets’ functions to convert birthdays to text quickly. First, she uses the `IMPORTRANGE` function to transfer the live data from one sheet to another. This way, any changes from the main sheet will also change the data in the second sheet.

Then, she uses the `TO_TEXT` function to quickly convert the birthdays, which are all in number format, into text.

But before we convert the numbers, let us first learn how to write the function.

## The Anatomy of the TO_TEXT Function

The syntax of the formula is shown below:

=TO_TEXT(value)

Next, we will learn the parts of the function.

• = the equal sign starts the `TO_TEXT` function in Google Sheets.
• TO_TEXT() is our `TO_TEXT` function.
• Value refers to the number that we need to convert into text.

## A Real Example of Using TO_TEXT Function

Since we already have an overview of how the function works and how to write it, we will proceed in solving the problem.

The given data are as follows:

 Employee’s Name Date of Birth Result Marjorie 09/29/1978 Karen 07/29/1988 Jessica 06/24/1990 Johnson 10/14/1975

Transfer or copy and paste the data into a spreadsheet. After doing so, key in the formula under results.

=TO_TEXT(value)

After you input the formula, it should show results like this:

To generate the returning value, here’s how to do it. But before we jump into it, click on the link below and solve the problem with me.

Are you ready? Let us start writing the `TO_TEXT` function and solve the problem with our guide below!

## How to Use TO_TEXT Function in Google Sheets

1. The first step is to key in all the data in the spreadsheet. This is to ensure that the data are correct and that you will not miss a single value. Otherwise, your returning value will yield an erroneous result.

2. The second step is to tell Google Sheets that we are working on a function. We will do this by first adding the equal ‘=‘ sign. Just cancel it by hitting the ‘BACKSPACE’ key if a popup appears.

3. After that, ensure that the cells contain no other character but the equal ‘=‘ sign.

Note: When writing the function, the TO_TEXT(), we will include the open ‘(‘parenthesis only.

4. Once done adding the function, we will start adding the value. There are two ways to add the value: selecting the reference value or adding the numbers manually.

1. Then, we will add the closing ‘)‘ parenthesis to complete the function.

1. Once the `TO_TEXT` function is complete, we press the Enter key to get the results. As to the problem above, here are the results of each employees’ birthday.

The reference value and the result may look different on the surface, but the result is a text format of the employees’ numeric birthday.

## Frequently Asked Questions

### What is the difference between Google Sheets’ TO_TEXT function and TEXT function?

The `TO_TEXT` function turns the reference value’s numeric format into text, while the `TEXT` function gives you more flexibility in converting the numbers. It allows you to precisely convert the numerical value of the reference into a specific string. For example, the `TEXT` function can covert 07/30/2010 into July 30, 2010.

### How to write the TO_TEXT function in Google Sheets?

The `TO_TEXT` function is written with one argument only.

Formula:

=TO_TEXT(value)

However, if the `TO_TEXT` function is combined with other Google Sheets functions like `ARRAY`, `QUERY`, and `IMPORTRANGE` functions, the formula becomes a little bit complicated for newbies.

Say, if you need to convert a specific value inside a specific range. For `ARRAY`formula, it can be written as:

=ARRAYFORMULA(TO_TEXT(CELL_RANGE))

When working with `QUERY`and `IMPORTRANGE` functions, the syntax of the function also changes. When all three are combined with the `TO_TEXT` function, the formula will look like this:

=ARRAYFORMULA(QUERY(TO_TEXT(IMPORTRANGE((SpreadsheetURL,RangeString)),”Select Col1 where Col1<>’ ‘ “))

### Can the TO_TEXT work when combined with other Google Sheet functions?

Yes, `TO_TEXT` is known to work with `IMPORTRANGE` , `ARRAY`, and `QUERY`functions. When all these functions are combined, the syntax becomes a little bit complicated. Thus, you need to familiarize each functions’ syntax and its rules to ensure that each syntax will now mess with the other.

## Summary

Working with the `TO_TEXT` function is easy. It only gets complicated when you are a newbie working with a combination of functions like `ARRAY`, `IMPORTRANGE` , and `QUERY`. The `TO_TEXT` function can help you in special cases when you may need to convert a value into a text without messing with its format.

Just make sure to familiarize the rules of the `TO_TEXT` function, and it will save you when times come that you may need it. But do not confuse this function with `TO_DATE` and `TEXT` functions. Though they sound similar, their function is entirely different from the other.

If you want to learn more about writing Google Sheets functions, you can check our website site for more Google Sheets functions. Also, make sure that you will not miss anything. Subscribe to our newsletter to get new updates. Lastly, comment below if you have questions or suggestions on what function we will cover next.

### Get emails from us about Google Sheets.

Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'd love what we are working on! Readers receive ✨ early access ✨ to new content.

Read More

## How to Remove Extra Characters from Strings in Google Sheets

Removing repeated characters from the end of strings in your Google Sheets document makes it much easier to…
Read More

## How to Copy a Formula Down an Entire Column in Google Sheets

You can easily copy a formula down an entire column in Google Sheets to automate your work and…
Read More

## How to Use REGEXEXTRACT Function in Google Sheets

The REGEXEXTRACT Function in Google Sheets is useful if you want to extract a certain text string within…
Read More

## How to Use VARPA Function in Google Sheets

The VARPA function in Google Sheets is useful when you need to calculate ‌variance based on an entire…
Read More

## How to Calculate Percentage Difference in Google Sheets

Learning how to calculate percentage difference in Google Sheets is useful for making comparisons by having a better…
Read More

## How to VLOOKUP Multiple Columns in Google Sheets

The VLOOKUP multiple columns in Google Sheets is useful if you want to pull out data from a…