image-2

Extract Numbers From a String in Excel (Using Formulas or VBA)

By Sumit Bansal There is no inbuilt function in Excel to extract the numbers from a string in a cell (or vice versa –  remove the numeric part and extract the text part from an alphanumeric string). However, this can be done using a cocktail of Excel functions or some simple VBA code. Let me first show you what Read More