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} <...

Hi! Can you please share the table you’re using? I am not sure if I know from the description how your table looks like.

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 “”).