'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Where to Find the GETNUMBERS Function in Excel 365
Question details
The user is attempting to use the GETNUMBERS function in Excel 365 but cannot locate it, leading to confusion about whether it is a standard built-in feature.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Trying to extract numerical values from a text string using a specific formula in an Excel worksheet.
- Observed behavior
- Excel returns a #NAME? error or fails to display GETNUMBERS in the formula autocomplete list because it is not a native built-in function.
Verify that your Excel Trust Center settings allow macros and third-party add-ins to run, as GETNUMBERS is a custom function that requires external scripts or add-ins to function properly.
Install a Third-Party Add-in Containing the Function
Since GETNUMBERS is not built-in, you must install the specific third-party add-in (such as DataFX) that provides this functionality.
Many specialized functions are bundled into downloadable add-in packages created by the Excel community. DataFX is a popular add-in that includes the GETNUMBERS function.
Navigate to the provider's website (e.g., excelkid.com) and download the add-in file (.xlam or .xll) that contains the GETNUMBERS function.
Open Excel 365, click on the 'File' tab, select 'Options', and then click on 'Add-ins' in the left sidebar.
At the bottom of the window, ensure 'Excel Add-ins' is selected in the Manage dropdown, and click the 'Go...' button.
Click 'Browse', locate the downloaded add-in file, select it, and click 'OK'. Ensure the checkbox next to the new add-in is ticked in the Add-ins dialog box, then click 'OK' to finish.
Create a Custom VBA Function (UDF)
If you do not want to install third-party software, you can recreate the GETNUMBERS function yourself using Excel's built-in Visual Basic for Applications (VBA) editor.
Looking for a powerful spreadsheet tool with robust macro support?
If you frequently rely on custom VBA functions and advanced formulas to process complex data, WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office. It seamlessly opens your existing workbooks and supports advanced spreadsheet operations without heavy resource consumption.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package.
- 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your device.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing Excel workbooks with full formatting and formula compatibility.
Frequently Asked Questions
Why does Excel show a #NAME? error when I type =GETNUMBERS()?
The #NAME? error indicates that Excel does not recognize the function name. Because GETNUMBERS is not a built-in standard function, Excel cannot process it unless the custom VBA module or third-party add-in containing it is properly installed and activated.
Can I use custom VBA functions like GETNUMBERS in Excel for the Web?
No. Excel for the Web does not support VBA macros or third-party COM add-ins. To use custom functions like GETNUMBERS, you must open your workbook in the desktop version of Excel.
Are there built-in alternatives to extract numbers from text in Excel 365?
While there isn't a single dedicated formula, you can use Excel's Flash Fill feature (Ctrl + E) by typing the desired number manually in the adjacent column, and Excel will detect the pattern. Alternatively, you can use modern dynamic array functions combined with TEXTJOIN, MID, and SEQUENCE to extract numeric characters without macros.
