Forum Discussion
An addition without changing the existing information
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!
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.
2 Replies
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.
