You can paste the lot into C2, make sure column D is empty, do datatext to
columns, select delimited, next and select space as delimiter, click finish,
that should put (216) in C2 and 444-3333 in D2
You can record a macro if you do this often and after you have pasted in the
same column just run the macro



--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"kbkst via OfficeKB.com" <u18755@uwe wrote in message
news:5bfe3e12973f8@uwe...
I previously submitted a question regarding copying and pasting a phone
number. I found that we no longer need to have a 1 in front of the phone
number..Yeah! My question now is: I am copying and pasting from a web
site
onto my spreadsheet. When I paste it comes out as (216) 444-3333. My
spreadsheet is set up as area code (C2), my phone number (D2). I would
like
to be able to paste into C2 which is area code, and have excel
automatically
move the phone number to D2. Is there a formula for this?
Thank you to all that have tried to help previously! Hope you can help
again.

kbkst

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