Question

what are regular expressions in spreadsheets? Give two examples​

Answer 1

Answer:

E.g. [a] matches the letter a.

E.g. [abc] matches a single letter which can be a, b or c.

E.g. [a-z] matches any single lower case letter of the alphabet.