VALUE
Converts a text argument to a number.
TextText CleaningText Processing
What it does
Converts text string representing a number to a number.
Syntax
VALUE(text)
Arguments
text(text) — String to convert.
Examples
Text to Number
Convert '123'.
FORMULA
=VALUE("123")RESULT
123
SAMPLE DATA
| A | |
|---|---|
| 1 | Text |
| 2 | '123 |