Skip to content
REFERENCE

U.PARSE_NUMBERS

Summary

Parses numbers out of arbitrary strings

Syntax

=U.PARSE_NUMBERS(input, [find_all], [no_sci_notation], [min_value], [max_value], [split_numbers], [return_input_if_error])

Parameters

Parameter Required Description
input Yes The cell or range of cells from which numbers are to be parsed
[find_all] No If set to TRUE then arbitrarily many numbers will be extracted from the string with each placed in its own result column
[no_sci_notation] No If set to TRUE then numbers in scientific notation will not be treated as numbers
[min_value] No If set to a number then only values larger than or equal to this setting will be found. By default filter is also applied to cells that are already numbers; include a 2nd column set to TRUE to always allow numeric cells to pass the filter
[max_value] No If set to a number then only values lesser than or equal to this setting will be found. By default filter is also applied to cells that are already numbers; include a 2nd column set to TRUE to always allow numeric cells to pass the filter
[split_numbers] No If set to TRUE then numbers will be subdivided to find attempt and find a result that satisfies any min_value and max_value constraints that exist. If explicitly set to FALSE then a dash will always be treated as a negative sign and not split away from subsequent digits
[return_input_if_error] No If set to TRUE then any input that cannot be parsed will be returned as is instead of an Excel #VALUE! Error. If set to a value other than TRUE or FALSE, that value will be returned instead of an error or the input if the input cannot be parsed into a number

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.PARSE_NUMBERS(B5)

=U.PARSE_NUMBERS(B6)

=U.PARSE_NUMBERS(B7)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.