EXTRACTNUMBERS
EXTRACTNUMBERS(sText, iNumberIndex, IncludeDecimals, IncludeNegatives)
Returns only the numbers from a text string.
| sText | |
| iNumberIndex | |
| bIncludeDecimals | |
| bIncludeNegatives |
REMARKS
concatenates all the numbers in a string 'iNumberIndex - which number to return if there is more than one 'IncludeDecimals - will include a decimal place in the concatenation 'IncludeNegatives - will include the last minus sign (before numbers) in the concatenation Function
![]() |
MORE FUNCTIONS
??
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext
