An addition without changing the existing information

[mflurry]

Hello!

I am trying to add a "+1" to phone numbers in my spreadsheet. When I try to add the +, Excel thinks I am trying to do a math equation. Is there a way to turn this off?

Also, when I receive my spreadsheets, the phone numbers are automatically in the sheet. Yet, where I need to upload them requires the "+1" in order to use them effectively. Is there a way for me to do this in bulk without it changing the existing data. When I tried dragging it down, it would take that same telephone number and replace all of the other ones below it. 

Thank you!

[#2 · Accepted solution]

@mflurry 

Let's say the phone numbers are in A2 and down.

If necessary, insert an empty column in column B.

Enter the following formula in B2:

="+1"&A2

or

="+1-"&A2

(whichever produces the desired result).

Then fill down.

If you wish, you can remove the formulas:

• Select the range with the formulas.
• Copy it.
• Click the lower half of the Paste button.
• Select Values.

You can now delete the original column.

[#3]

@Hans Vogelaar 

That's it. Thank you so much! You've saved me hours of time!