Wednesday, 15 August 2012

validation - Google Spreadsheets: - Validating cell contains only alphanumeric and underscore -


Text after "div class =" itemprop = "text">

Google Sheets, How do I (using regular expressions) to use a custom formula, only alphanumeric permissions and Underline the characters in the cell contents? 3 main formulas used to verify a regular expression (you can find the formula document)

Are:

  • REGEXEXTRACT: Substring matching extracts according to a regular expression
  • REGEXMATCH:. Whether or not a part of the text matches a regular expression
  • REGEXREPLACE:. Changes part of a text string with a different text string using regular expression.

You can use these formulas to test expressions. This page should help you learn how to take advantage of these formulas. Also see Regular Expression Part 2

Alternatively, if you are using Google Forms to submit data to your spreadsheet, then you can add field validation for each question.


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)