VALUE

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

Syntax

value(value:string)

Arguments

value - Required. A text string containing a number.

Example

value(MID"ABC-123-WEW",5,3))

Returns “123” as a number

Excel equivalent

VALUE