SJ --

And, if the telephone numbers have the possibility of coming in different
lengths, then use what Dave O said and something kind of clumsy like this,
since you mentioned the "f:" and "p:"


=RIGHT(a1,(((LEN(a1)-1)) - (SEARCH("f:",a1))))

"Dave O" wrote:

Formula in B1:
=MID(A1,1,FIND("p: ",A1,1)-2)

Formula in C1:
=MID(A1,FIND("p: ",A1,1)+3,12)

Formula in D1:
=RIGHT(A1,12)

These formulas rely on the assumption that the cell in column A will
always have "p: " and that telephone numbers will always be in
###-###-#### format.