Forum Discussion
Solved
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 receiv...
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.
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.
