by John MacDougall | Dec 5, 2016 | VBA
In this post we’re going to explore how to find and remove multiple text strings from within another string. Excel has a great built in function called SUBSTITUTE which allows you to find one bit of text within another text string and substitute it for another...
by John MacDougall | Dec 5, 2016 | Tips
In this post we’re going to find out how to get the position of the first number within a text string. Let’s suppose we have stock level data for a grocery store and in our example someone has gone and put both the item and stock quantity in one cell...
by John MacDougall | Dec 4, 2016 | Tips
Unlimited Format Painter When you click the format painter you will be able to use it once, but if you double click it then you will be able to use it an unlimited number of times until you click the button again to turn it off. Highlight the area you...
by John MacDougall | Dec 3, 2016 | Tips
In this post we will explore how to create a drop down list with dynamic content. This means the content of the drop down list will depend on another selection and some set of data. In our example we have a set of product order data that contains a customer ID, and...
by John MacDougall | Dec 2, 2016 | Power Query
In this post we’re going to explore how to pull data from a table on a webpage into Excel. In our example we are going to pull stock price data from Google Finance for a given company. As this type of data is updated frequently (ie the market value of a stock...