Forum Discussion
How do I add "1" before phone numbers on excel
The phone number that I exported to excel sheet do not have (1) in front of them, so how do add that number?
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.
I am sorry , can you clarify?
Did you go back to the OneDrive sheet? I gave you the solution there.
Either way, what are you asking me to clarify?
- Never mind. I just saw it Thank you very much for your help