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.
|