Will the number after the RR always be a single digit? If so, you could use:

=IF(LEFT(B1,2)="RR",MID(B1,4,1),"")

If the number will be of variable length, then try:

=IF(LEFT(B1,2)="RR",MID(B1,4,FIND("~",SUBSTITUTE(B 1," ","~",2))-4,"")

HTH
Elkar


"mailrail" wrote:

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!