Steve Yandl:
Thank you so much for your response but I am coming up with a #REF. My
spreadsheet is actually B2, C2 and D2. I don't know if the formual has to
change for this. I tried putting in the B2 within the formula but it is not
working. Hope to hear from you.
kbkst

Steve Yandl wrote:
If the format is always the same (all numbers have the area code, always
have the 1 in front and the space after the area code, you could try this.

If your phone number is pasted into B1, in C1 you could have
=MID(B1,3,3)
and then in D1 you could have
=MID(B1,8,3)&MID(B1,12,4)

You would drag the fill handles on the two entered formula far enough to
handle all the rows where you've pasted numbers in column B. If the phone
number format sometimes varies, you will need to expand the formulas with
some IF functions.

Steve

This may not be able to be done, but it doesn't hurt to ask.

[quoted text clipped - 11 lines]
Thanks,
Shaety

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200602/1