View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SCrowley SCrowley is offline
external usenet poster
Posts: 47
Default 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

So that Cell P2 (current contents are 5255551212 x182) will result as
525-555-1212 x 182 AND/OR to substitute any numbers entered as (525)
555-1212, 525.555.1212, etc.

Thank you,