Saturday, August 13, 2011

yogi_Reformat 10-Digit Phone Numbers In Form Responses Sheet For Uniformity


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

In this spreadsheet 10-digit phone numbers in Form Responses sheet have been entered by submitters in various styles with one or more of the following characters, /,-,., space character, (, and 0. I then I take the 10-digit phone numbers as they were entered and using a computed column (shown with brown colored background) I present them formatted in one uniform style across the board.
-------------------------------------------------------

7 comments:

  1. THX!! This was even easier to use than the one I found last year. Great that it automatically applies to rows below without copying and pasting.

    ReplyDelete
  2. Hi katbrain:

    Glad to hear this works for you ... Now Let Us Keep Googling.

    Cheers!
    Yogi

    ReplyDelete
  3. worked for me like a charm just now on 4323315553 style numbers - to US phone format. Thanks!

    ReplyDelete
  4. Hi Sean:

    Great ... Now Let Us Keep Googling.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete
  5. hi good day, is there a way to reject of input with same number?? e.g. user enters exactly the same number that was already on the Form Response.

    ReplyDelete
  6. Hi kel_TekNix:

    Greetings!

    I will add a sheet to suppress duplicates phone numbers -- I will post the reference to the work with unique phone numbers when ready.

    Make It A Great One
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete
  7. How can i hold the form or validate while taking input if the entry is not 10 digits. The validation on cell haven't helped me?

    Will be great ..

    ReplyDelete