| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Revision
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a revision date to an Excel document | Excel Worksheet Functions | |||
| Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
| can a revision # be updated across multiple worksheets in the head | Excel Worksheet Functions | |||
| Multipl IF Statements - REVISION | Excel Worksheet Functions | |||
| Revision Number | Excel Worksheet Functions | |||
Threaded Mode
