Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Text functions

NUMBERS

Returns only numbers from a range.

 

Sample Usage

NUMBERS(20,30,"abc")
NUMBERS(A2:A6)

Syntax

NUMBERS(value1, [value2, ...])

  • value1 - The first value or range to consider.
  • value2, .. - [OPTIONAL] Additional numbers or ranges to consider.

Examples

NUMBERS(20,30,"abc") returns the numbers 20 and 30 separated by a comma.
NUMBERS(A2:A6) returns the numbers in the range A2 through A6.