I'm not an Excel guru by any means, but one of our users has asked me to come up with a way to extract certain data from a column cells in an Excel spreadsheet. Given the following examples, how could I extract the middle numbers and end numbers from the following values?
103-4-25 (I'd want to extract 4 and 25)
99-07-113 (I'd want to extract 07 and 113)
75-1-004 (I'd want to extract 1 and 004)
I guess what I'm looking for is a couple of formulas that I can paste in a couple of cells to grab this data. Can someone point me in the right direction?