Posted to microsoft.public.excel.worksheet.functions

SCrowley

external usenet poster

Posts: 47

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
525-555-1212 x 182 AND/OR to substitute any numbers entered as (525)
555-1212, 525.555.1212, etc.

--
Thank you,

scrowley(AT)littleonline.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine Formulas	Dennis1188	Excel Discussion (Misc queries)	5	March 5th 07 09:34 PM
how to combine formulas to.........	gmisi	Excel Worksheet Functions	5	January 13th 07 08:47 PM
Using an IF to combine multiple formulas	sharkfoot	Excel Discussion (Misc queries)	5	April 2nd 06 06:21 PM
Combine 2 formulas	Steved	Excel Worksheet Functions	3	August 8th 05 10:09 PM
Help combine 2 formulas into 1	Robert	Excel Worksheet Functions	5	April 1st 05 08:55 AM

All times are GMT +1. The time now is 06:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us