How to remove number from a string and keep only text characters

+3

Hello,

Can you help me how to remove number from a string and keep only characters please ?

Example : Value "123ABE89" to "ABE"

Or if you have an other skills with calculated value in SharePoint column i am OK too thanks in advance.

Regards,

Vijay Antoine MICK

+3

Hello to all,

I want to extract only TEXT char with Regular Expression Extract en remove Numbers

Example

123ABC -> ABC

Regards,

+8

Assuming you want to only remove numbers, you can use D (any non-digit) as regular expression

+3

Thanks for you reply, I found the solution I use [0-9]+ in my regular expression pattern and it works

Use regex. Maybe this can help you:

Pattern: ([0-9])+

Operation: Replace text

Input text: the value that you can replace, in this case 123ABE89

Example:

-> save the result in a new variable

+3

Thanks luiztux it works

Sign up