Way to put a "1" in front of everybodies number in contacts

Discussion in 'Android General Discussions' started by cisco0910, Mar 25, 2010.

  1. cisco0910

    cisco0910 Member

    Joined:
    Nov 26, 2009
    Messages:
    838
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Virginia Beach, VA
    Ratings:
    +0
    Is there an easiest way to put a one in front of everybodies number in your contact list? Manually would take forever.
     
  2. sam5828

    sam5828 Member

    Joined:
    Feb 5, 2010
    Messages:
    192
    Likes Received:
    0
    Trophy Points:
    16
    Ratings:
    +0
    why? ya dont need to
     
  3. hookbill

    hookbill Premium Member
    Premium Member

    Joined:
    Nov 30, 2009
    Messages:
    19,502
    Likes Received:
    8
    Trophy Points:
    168
    Location:
    N.E. Ohio
    Ratings:
    +8
    I don't know of any. If I had to do it, I'd do it in gmail on line. 1 and copy paste it.

    You looking for the 1 for Skype?
     
  4. keiichi25

    keiichi25 Member

    Joined:
    Nov 6, 2009
    Messages:
    364
    Likes Received:
    0
    Trophy Points:
    16
    Ratings:
    +0
    You don't really need the '1' in front of the numbers. Current US Cellphone technology assumes you are calling in the US and numbers with Area Codes will be considered 1+Number. If you only put in 7-9 digits (Which is the standard 7 Digits or some who put in a little more in their phone number), it presumes you are dialing a local area code number based on your cell tower, (I believe).

    I know for PBX systems for companies, when you get T1 lines going into it, depending on who the provider is, you can set the system to ignore or require.
     
  5. Cyrus6001

    Cyrus6001 Member

    Joined:
    Mar 5, 2010
    Messages:
    173
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    NY
    Ratings:
    +1
    Export your contact from gmail into .csv format. Open that csv file in excel. Once in excel you can select the colum with the numbers and add the "1".

    Anybody here good with excel? I know theres an easy way to add the digit, i just haven't had to do it in a long time. Theres some type of data formula you can run that will allow you to specify that you want to add to the data colum and where. So in your case you want to add a "1" before yout data string(i.e. phone numbers).
    Then just import the csv back into gmail
     
  6. Cyrus6001

    Cyrus6001 Member

    Joined:
    Mar 5, 2010
    Messages:
    173
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    NY
    Ratings:
    +1
    Ok so its the Concatenate function
    So take your list of phone numbers. Insert a column to the left of those numbers. fill each cell in the new column with a 1. The run the above function to combine both cells. And viola! all ur numbers now have a 1 in front of them
     
  7. ldimick

    ldimick Member

    Joined:
    Nov 28, 2009
    Messages:
    629
    Likes Received:
    0
    Trophy Points:
    16
    Ratings:
    +0
    A1 contains the phone number
    cell B1 would say ="1"&A1
    Then copy the B1 column and do a Paste Special of B1 to A1 and replace the results ONLY. Then delete column B. Should work.
     
  8. Cyrus6001

    Cyrus6001 Member

    Joined:
    Mar 5, 2010
    Messages:
    173
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    NY
    Ratings:
    +1

    That works too.
     
  9. Corinacakes

    Corinacakes Super Moderator
    Theme Developer

    Joined:
    Nov 17, 2009
    Messages:
    5,009
    Likes Received:
    3
    Trophy Points:
    153
    Location:
    Maine
    Ratings:
    +3
    There's a free app in the market called "contacts clean-up" that does this :D
     
  10. mikes

    mikes Member

    Joined:
    Jan 10, 2010
    Messages:
    304
    Likes Received:
    0
    Trophy Points:
    16
    Ratings:
    +0
    If you're going to do it, do it right, and make it proper E.164 format by adding "+1"
     
Search tags for this page
add a 1 to phone numbers in excel
,
adding a one before phone number
,
android contact do i need to put a 1 before the number
,
excel add digit in front of number
,
how to add 1 in front of a number in excel
,

how to add a 1 in front of numbers in excel

,
how to insert a 1 in front of each phone number for csv file
,
in excel how do i add a 1 in front of a number
,
is tehre a way to put 1 in front of all contacts
,
why is there a 1 in front of my area code on tracfone phone number