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