Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Calling Add-in functions from VBA
- About Newton Excel Bach
- Downloads
- Cubic Splines
- XLDennis, the MSDN Library, and VBA rant
- Linking Excel to C - 2
- Filling Blanks with Go To-Special (and local help rant)
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
Tag Archives: extracting numbers from text
More on Regular Expressions
The previous post presented a User Defined Function (UDF) using regular expressions to extract all numbers, or a selected number, from any string (or a list of strings). In this post I will look more closely at the code used to achieve … Continue reading
Posted in Excel, UDFs, VBA
Tagged Excel, extracting numbers from text, regular expressions, UDF, VBA
10 Comments
Extracting numbers with regular expressions
Shortly after I wrote about extracting numbers from text strings, Winston Snyder at dataprose.org wrote a detailed article about using “regular expressions” to separate text from numbers in any string. I have adapted his routine for the same purpose as … Continue reading
Posted in Excel, UDFs, VBA
Tagged Excel, extracting numbers from text, regular expressions, UDF, VBA
19 Comments