Joshua earned an MBA from USF and he writes mostly about software and technology.
The Purpose of the VALUETOTEXT Function
The VALUETOTEXT function gives an Excel user the ability to change any value in a cell to a text value. For instance, you may need a numeric value to appear in a text format to avoid formatting issues.
The VALUETOTEXT Function Syntax
The VALUETOTEXT function needs to be inputted into a cell like a formula for it work. To manually add this function, the following steps need to be taken:
- A cell needs clicked type "=VALUETOTEXT(".
- After the open parenthesis
- Next, include the type of format. 0 for concise or 1 for strict.
- Lastly, add a closed parenthesis followed by entering the formula.
Below in bold the syntax of the VALUETOTEXT function is shown in its entirety. This is followed by detailed definitions of each argument in the formula.
Value - This is the cell that contains the value that is to be converted to text.
Format - Concise 0 or strict 1 is chosen. When the strict format is chosen text may be converted to show escape characters and row delimiters.
In the first example below, only one argument is used to covert a numeric value to a text value. A '1' could be added to the format argument but unnecessary.
In the second example, an already existing text value is used with a '2' as the format argument. The result shows escape characters (or quotes) outside of the text.
Inserting the VALUETOTEXT Function
The VALUETOTEXT function can be inserted in a cell to make the functional arguments more clear. To use this method you need to first select the cell where you need you result to appear. Next, click on the formulas tab and select the Text button. Choose VALUETOTEXT from the list of functions.
After the formula builder has appeared, you can start adding arguments. When new values are added to these argument field, the results are displayed at the bottom of the formula builder.
Also, notice the tips that are given within that sidebar. To print the results into the cell, click Done.
Microsoft. (n.d.). VALUETOTEXT function. Retrieved July 20, 2022, from https://support.microsoft.com/en-us/office/valuetotext-function-5fff61a2-301a-4ab2-9ffa-0a5242a08fea
To learn more about using functions in Excel I recommend The Excel 2019 Bible book. I have been using the Excel Bible for years to improve my understanding of all aspects of this Microsoft product.
This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.
© 2022 Joshua Crowder