simple excel formula

This project received 27 bids from talented freelancers with an average bid price of $40 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

This is a project that might now even be a project...I would appreciate any help you can give a formula for a cell in an excell sheet that simply adds a 1 in front of the phone numbers in a column of cells. BTW, I manage a few companies and have editing, programming, data manipulation, legal, etc. work all the time and would appreciative if someone could send me this excel code "gratis" - my usual source cannot be reached today.. I will return the favor by sending you the type of work you do for other projects.. I do not need any other fancy spreadsheet, just one formula for one cell that I can copy down..

At any rate, the attached spreadsheet is a column with phone numbers I wish to call. In order for my dialing software to dial correctly, they need to have a 1 in front o the 10 digit number. Since I will need to add the 1 to hundreds of phone numbers each week into the future, I'd rather not do this individually, but instead find out the function that will turn the first column into the same number with a 1 on it. i.e. 214-723-3492 would now be: 1-214-723-3492. I don't think the dashes matter.. Does anyone know the function or can write this function?


Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online