How to delete a space between texts?

Question
1

Hello all,

I’d like to delete a space between texts.

I’d like to “CONTAINS(TEXT1, TEXT2)”, but the number of spaces does not match and “CONTAINS” is not successful.
ex. TEXT1=“an apple”, TEXTS2=“an apple”

Please help me.

2

Use REPLACE_ONE_REGEX("words with spaces", \s+, "")
I do not know how to insert regex like \s+ inside the formula. Plain or between single or double quotes. Just makes some tests.

1 Like