Google Spreadsheet Post #2107
How to add specific text to range of cells containing cellular phone numbers?
Hello I was trying to edit my exported google contacts as a google spread sheet and edit the telephone numbers, unify them, and delete the duplicates.
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-11-2017
question by DrNasef OrthClinic:
https://productforums.google.com/forum/#!topic/docs/DuLlELkK_PI;context-place=mydiscussionsHow to add specific text to range of cells containing cellular phone numbers?
Hello I was trying to edit my exported google contacts as a google spread sheet and edit the telephone numbers, unify them, and delete the duplicates.
I noticed almost all my numbers lack the starting digit "0" for cellular numbers. (Proper format being : 0XXXXXXXXXX)
I would like to add the following : "+20" to all these numbers in a certain column
So say I would like to add "+20" to all cells in column AL from AL1 till AL3480
Is there a "formula " for that ?
Thank you and naturally any help is highly appreciated
P.S
If anyone could also point out how to erase the duplicates in the easiest possible way I would be very grateful. It is a real pain sifting through almost 4000 contacts!!
No comments:
Post a Comment