View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

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.