In column A, there are some alphanumeric entries. Somewhere in the alphanumeric entries (beginning, middle or end) there are the following: 1. Dates 2. Numbers (without decimals) 3. Numbers (with decimals) Furthermore, there may or may not be spaces between numbers/dates and text entries. In Excel 2010 and prior versions, the only way to solve this problem would […]
Read More →
Extract numeric data and dates from string
{ 12 Comments }