I need a formula that will examine a cell for a certain value, then return a
specified portion of that value to another cell. For instance, B1 = RR 4 Box
154. B2 = PO Box 555. I need a formula in the corresponding A column (A1 for
instance) that, if the cell begins with "RR", it will return that value
(along with the number beside it - 4 in the example above) to A1. If it's
doesn't begin with "RR" then I don't need a return. Any help greatly
appreciated. You guys and gals are the masters!