Problem description & analysis

Below is an Excel file book1.xlsx:

We are trying to extract numbers from each of column B’s strings, and get the first one to enter into column E. The expected result is as follows:

Solution & explanation

Load add-in ExcelRaq.xll in Excel, and

Enter the following formula in cell E2: =esproc("=?.words@d()(1)",B2). Enter similar formulas in the other cells to get results.

Q & A Collection

https://stackoverflow.com/questions/63775486/how-to-extract-specific-text-from-a-field-in-excel