Examples

EXTRACTNUMBERS("My name is Theo and I’m three and a half years old!"): LIST(3.5)

EXTRACTNUMBERS("Tommy: I left a message. Richard: Really, what number did you call? Tommy: Two, four, niner, five, six, seven…”): LIST(2, 4, 5, 6, 7)  (Note: niner is not a number!)

EXTRACT("NUMBERS", "The address is 330 SW Main St, 97229”): LIST(330, 97299)

Syntax

EXTRACTNUMBERS(“text-to-extract-from”)

Arguments

text-to-extract-from (text)

Return Value

A list of Decimal values. 

See Also

EXTRACT(), EXTRACTCHOICE(), EXTRACTDATES(), EXTRACTDATETIMES(), EXTRACTDURATIONS(), EXTRACTEMAILS(), EXTRACTHASHTAGS(), EXTRACTMENTIONS(), EXTRACTPHONENUMBERS(), EXTRACTPRICES(), EXTRACTTIMES()

Did this answer your question?