Wednesday, February 23, 2011


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

fanny.o said ...
I have a column with tel numbers but they are in different formats.
99 99 99 99 99
and i want to have the tel numbers always in the following text format : 99999999
How can I do that with a script ?
I put the formatted numbers in various styles in column B from, and I used in cell C2 of Sheet1 my formula using the SPLIT function, and the SUBSTITUTE function  ...