VALUE

The VALUE function converts a text string that represents a number to a number.

Syntax

value(value:string)

Arguments

value - A text string containing a number. Required.

Example

value(MID"ABC-123-WEW",5,3))
//Returns “123” as a number

Value function

Excel equivalent

VALUE