How to find the minimum and maximum values within a specified set of years in Excel Your email has been sent Image: iStock/Rawpixel Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft ...

Open a new Microsoft Excel 2010 worksheet. Click on cell "A1" and enter the values in your data set into the cells in column A. Click on cell "B1." ...

As you can see, FIND() returns a value, not a character. This value represents the position of the found character, in this case, the hyphen character. SEE: How to parse data in Microsoft Excel.