 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008How do I add a 1 to all phone #s(cells) in a column?
I have a 5000+ list of phone #s in an excel sheet. I need to add a 1 to each of them. The numbers look like this: 9545555555. I wabt to add the 1 prefix without a dash or space. Could someone be so kind as to help this newbie??? Hi Pookie954 ="1"&A1 This formula will add 1 to the numbers, just type in with the right reference eg:"A!" and copy down. Regards Cimjet >I have a 5000+ list of phone #s in an excel sheet. I need to add a 1 to >each > of them. The numbers look like this: 9545555555. I wabt to add the 1 > prefix without a dash or space. Could someone be so kind as to help this > newbie??? Thanks Cimjet. Could you elaborate on "copy down?" Thx > Hi Pookie954 > ="1"&A1 This formula will add 1 to the numbers, just type in with the right [quoted text clipped - 6 lines] > > prefix without a dash or space. Could someone be so kind as to help this > > newbie??? After entering the formula in the first cell, move the cursor towards the bottom right of the cell until the cursor changes to a thick black cross. At that point click the left mouse button, and drag the formula down. BTW, I would use a formula of =10^LEN(A1)+A1 to preserve it as numeric.  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Thanks Cimjet. Could you elaborate on "copy down?" Thx > [quoted text clipped - 10 lines] >> > this >> > newbie??? Hi Bob, I'm confused on two counts. 1 Why would you need to preserve phone numbers as numeric? 2 If for whatever reason you do want to preserve them as numeric why use a function call instead of just =("1"&A1)*1 ? Not trying to be a smarty, just intrigued. Martin > After entering the formula in the first cell, move the cursor towards the > bottom right of the cell until the cursor changes to a thick black cross. [quoted text clipped - 22 lines] >>> > this >>> > newbie??? Thank you both ( Bob & Martin ) for the information. I never realized I was changing the format. I learn something everyday on these newsgroups and loving it. Maybe one day will be has good as you guys. Regards Cimjet > Hi Bob, > [quoted text clipped - 34 lines] >>>> > this >>>> > newbie??? Thanks a bunch. It worked! > After entering the formula in the first cell, move the cursor towards the > bottom right of the cell until the cursor changes to a thick black cross. At [quoted text clipped - 20 lines] > >> > this > >> > newbie??? QUOTE: "Thanks Cimjet. Could you elaborate on "copy down?" After writing the formula, select the cell containing it. You will see a small square in the bottom right corner of that selected cell. Put the mouse cursor over it, and drag it downwards. _________________ 'Excel 2007 tutorial' (http://www.microsoft-office-excel.com) Signaturejackgopher Thank you. This worked perfectly! Problem solved. > QUOTE: "Thanks Cimjet. Could you elaborate on "copy down?" > [quoted text clipped - 4 lines] > _________________ > 'Excel 2007 tutorial' (http://www.microsoft-office-excel.com)
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.