How can I combine two formulas Left/Mid/Right + Substitute?
Excel 2007  records with varying formats of phone numbers+text.
I would like to combine =LEFT(P2,3)&""&MID(P2,4,3)&""&RIGHT(P5,4) to
separate any numbers entered as 5555551212 AND/OR
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTI TUTE(P2,"
",""),"(",""),")",""),".",""),"/","")
So that Cell P2 (current contents are 5255551212 x182) will result as
5255551212 x 182 AND/OR to substitute any numbers entered as (525)
5551212, 525.555.1212, etc.

Thank you,
scrowley(AT)littleonline.com
