How to extract the numeric portion of a street address in Excel

Microsoft Excel provides many features to handle the text data along with numeric data. There are many functions available to join, split and merge data in Excel. The data could be text only, numeric only or it could be alphanumeric as well. Sometimes, while working with city addresses, we need to split up the addresses … Read more