I would like a formula that will separate out the letters and numbers form input into one cell. Say cell "A!" has "S30G in it. I would like cell A2 to separate out the "S" and give that answer only in cell A2 and in cell A3 I would like the 30 number to be the number that is given as an answer in cell A3 and in cell A4 I ould like the G as the answer. There will always be one letter in front, 2 numbers in middle and one letter following i.e. "S#)G" or "D45B" .