Ok, so if I understood correctly you need below formula:
IF(AND({Number of people} >= 2, {Number of people} <= 4), {Price 1},
IF(AND({Number of people} >= 5, {Number of people} <= 6), {Price 2},
IF(AND({Number of people} >=7, {Number of people} <...
If you don’t want to worry about capital letters or not, this should do it:
SUBSTITUTE(REGEX_REPLACE(Notes, "\\B[a-z]", ""), " ", "")
I’ve checked it and it seems to work. I’m not an expert in regex though, I just try and see what happens :grinning...
Hi there! Try this:
REGEX_REPLACE({Race (d12)}, "\\d+\\.\\s", "")
This formula uses regular expressions to replace combination of number, period and empty space with a given string (in our case empty string “”).
Hi there! What you did will only extract the letter G from the example you’ve provided. It’s because according to documentation REGEX_EXTRACT returns only the first occurence that matches your regex. I thought it’s not possible but I’ve played a whil...
