yogi_ConvertTelephoneNumbersFromDifferentFormats

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

fanny.o said ...

I have a column with tel numbers but they are in different formats.
Tel
99.99.99.99.99
99 99 99 99 99
9999999999

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  ...