Wednesday, January 11, 2017

yogi_Add Specified Text To Range Of Cells Containing Phone Numbers

Google Spreadsheet   Post  #2107
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=mydiscussions
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. 
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!!