I have a spread sheet with a column of phone numbers in it. All are in 11 digit format and sequential from 17775551000 - 17775551999
My goal = Take each number and prefix a \+ and then put a period after the 1.
For example. 17775551000 will be come \+1.7775551000
I figured this out for the slash and the plus -> ="\+"&A1&""
How do I get the period in there as well?
Thanks in advance!
Bookmarks