Category Archives: Excel

More on Regular Expressions

Posted on 08/12/2014 by dougaj4

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 , , , , | 10 Comments

Extracting numbers from text and regular expressions

Posted on 30/11/2014 by dougaj4

Daily Dose of Excel recently had a post on extracting a number from a specified position in a text string, using mega-in-sheet-formulas like: This reminded me of a post from earlier this year, which provided a User Defined Function (UDF) … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 4 Comments

Range tips

Posted on 17/11/2014 by dougaj4

A couple of tips on Excel ranges, coming from questions on the Eng-Tips Forum: 1. How to rotate a range: The Transpose function (or option in the Paste-Special dialog box) will swap the rows and columns of a range, but … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , | 6 Comments

Section Properties Update

Posted on 02/11/2014 by dougaj4

The Section Properties spreadsheet provides formulas for the section properties of 35 different defined shapes, calculation of section properties from coordinates, and interactive calculation and plotting of any chosen shape with defined dimensions: The latest version added the function to … Continue reading →

Posted in Excel, Maths, Newton, VBA | Tagged , , , | 2 Comments

Assorted links

Posted on 26/10/2014 by dougaj4

A collection of useful Excel and science/engineering related links that I have discovered/rediscovered recently: Craig Hatmaker’s Beyond Excel: Everyone knows Microsoft Excel is a powerful data mani-pulation engine, but data lives in databases and only a few Excel experts know … Continue reading →

Posted in Excel, Link to Python, Maths, Newton | Tagged , , , , , | 1 Comment