Inserting country code "1" into an existing column of phone numbers

[Snowyky]

I've searched and searched for a simple way of doing this, I need to add the country code "1" to an existing spreadsheet that has a column of fax numbers. We use a delimited file to send faxes to the numbers and I wanted to add the 1 to the spreadsheet before I add the file to our database. Any help would be much appreciated.

[shg]

=1 & A1 and copy down.

[Snowyky]

I'm sorry, I don't know what to do with your answer, I'm a real newbie, what are the steps to accomplish this?

[Snowyky]

I guess I should explain, I get the =1&A1 to work but I need the result to replace the original fax number so I can then make it into a delimited file to import into our database. I'm not sure the steps I need to take to accomplish this. I want to end up with the 1 added to each fax number and the only columns I have are the original columns... Company, Fax number. Thanks

[shg]

Apply the formula, then copy the results, and paste special over the original data.

If the phone numbers are all exactly the same length, then you could do something else ...

[Snowyky]

It worked great, thanks alot, I checked the values box in the paste special window and it worked perfectly. Thanks again

[shg]

Good job, you're welcome.