Forum Discussion
How do I add "1" before phone numbers on excel
mathetes So if I wanted to change the number from (352) 123-4567 to 1(352)123-4567, then I type the following: "1"(352)123-4567? I tried that and it did not work
By the way, did you look at the sample file I attached in my first reply?
I demonstrated both possible solutions. That file, plus the explanations in that first answer, is fairly complete. Either part by itself, though, is incomplete,
- SamarHennawiMar 06, 2024Copper ContributorThank you so much for your help. Maybe you are clear, but I am not versed in this at all. Here is the link. I hope it works
https://1drv.ms/x/s!AgiQOzOlQ0mKhOpTg4gyDOxDyBo_bg?e=cAlEb7- mathetesMar 06, 2024Silver Contributor
Maybe you are clear, but I am not versed in this at all.
That much IS clear. You're to be commended for recognizing that fact and coming for help.
Here is the link. I hope it works
It did work. You should be able to go back to that file in OneDrive and open it to see what I did.
Now: IF that sample is in fact the same as your actual, those phone numbers are stored as text. So I used the simple concatenation formula to add the 1 in front. That formula is in the cell immediately to the right of your sample data. As such it could be copied and pasted to your actual.
- SamarHennawiMar 06, 2024Copper ContributorI am sorry , can you clarify?