Wednesday, February 23, 2011

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

No comments:

Post a Comment