Saturday, August 13, 2011

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

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

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.