HOW TO REMOVE DIGITS IN A STRING

Hi how can I remove the number "1" in the string "1 TOTAL ACCUM DEPN". What is the formula for this?

Adobe

Accepted answers

Try formula like this

Trim(REGEX_Replace([Field1], "\d", ""))

Hope this helps : )

You can use formula like this

Trim(Replace([Field1], "1", ""))

Hope this helps : )

Hi how about if I have a lot of numbers in a string?

Try formula like this

Trim(REGEX_Replace([Field1], "\d", ""))

Hope this helps : )