Cancelled

simple excel formula

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?

Thanks!

Skills: Data Entry, Excel

See more: rate copy editing, project software gratis, programming excel 2010, source data entry companies, numbers function, need help excel editing, need excell help, me excel, function numbers, formula it, excel source, excel data programming, excel add programming, dial code, copy editing rate, cell phone programming, anyone need help editing, excel simple formula, excel spreadsheet formula, excel sheet formula, excel help formula, simple excel, excell work, excel work today, excel type work

About the Employer:
( 24 reviews ) Dallas, United States

Project ID: #749301

27 freelancers are bidding on average $40 for this job

FINGERRPRINT

PLEASE SEE OUR PM

$30 USD in 1 day
(167 Reviews)
7.4
fareastern

Please check your PMB.

$30 USD in 0 days
(131 Reviews)
7.0
koolsidz

Please see PMB

$30 USD in 0 days
(110 Reviews)
6.0
spawar

Hi, I will solve this problem immediately. Please send me the xls file will fix and send it to you immediately.

$30 USD in 1 day
(47 Reviews)
5.9
wsh2

Although as a Philadelphia E-A-G-L-E-S fan it grieves me greatly to help a Dallas "Lowboy'.. er.. 'Cowboy'.. the truth is.. any half way decent dialing program should handle the 1 (country code) prefix without a hitch. More

$30 USD in 1 day
(18 Reviews)
5.4
HussienSharaf

HI, I can help immediately Hussien Sharaf

$30 USD in 1 day
(18 Reviews)
5.3
hemi

Hi, please check your inbox for best solution. Thanks - hemi

$30 USD in 0 days
(28 Reviews)
4.8
himanshusofttech

Hi, please check PMB for details

$30 USD in 0 days
(34 Reviews)
4.7
mantripti

Hi, I am Mechanical Engineer, M Tech & MBA + Cost Management Account. I have a team support of number of professionals, including IT engineers, Computer professionals. We also have a manpower support of 40 PC. We have More

$30 USD in 1 day
(21 Reviews)
4.1
mike25

Please see PM- i will send it for free there.

$30 USD in 0 days
(9 Reviews)
3.6
asr2009

Please see PM

$30 USD in 0 days
(3 Reviews)
3.4
ifaisal

I tell you for free, just for a positive review.

$30 USD in 1 day
(4 Reviews)
3.4
florinserban

Hi. Please check PM. Thanks!

$30 USD in 0 days
(2 Reviews)
3.2
ruimaxwell

Hi. Please check PM. Thanks

$30 USD in 1 day
(2 Reviews)
2.7
Abikris

Hi, Check your PMB

$30 USD in 0 days
(5 Reviews)
2.5
shaildeogam

Hi, I am interested in this project and ready to start it immediately. Please see PMB. Regards!

$30 USD in 0 days
(2 Reviews)
1.6
FinanceMike

Please see your PMB. Thank you.

$30 USD in 0 days
(1 Review)
1.4
cmattoon

No charge; see PM.

$30 USD in 1 day
(1 Review)
0.0
nhydaruae

I am expert in this and same functions & fomulas are my daily routine. can be provide with in hour.

$100 USD in 1 day
(0 Reviews)
0.0
Rubel19b

Dear Sir I have data entry skill with excel and typing spread . You can choose me for quallity anc cheap. Regds Rubel

$30 USD in 2 days
(0 Reviews)
0.0