Extract Text only

[JDong]

Hi,

Please refer to the below table. I want to create a lookup 

6.100 Orange

6.110 Mango

6.120 Mango and Oranges

6.130 Kiwi

6.140 Doughnut with cream

6.150 Salad

6.160 Blueberry

6.170 Raspberry

6.180 Muskmelon

6.200 Salad with Cream / Salad with Meat

Watermelon

Banana

6.230 Grapes with Strawberry and Pineapple

I only need to extract the text here so the final lookup needs to be as shown below

Orange

Mango

Mango and Oranges

Kiwi

Doughnut with cream

Salad

Blueberry

Raspberry

Muskmelon

Salad with Cream / Salad with Meat

Watermelon

Banana

Grapes with Strawberry and Pineapple

Please help with your thoughts.

Thanks

[Jonathan-Sherman]

Hi @JDong,

What output are you wanting from it?

Regards,

Jonathan

[JDong]

@Jonathan-Sherman 

Edited the question with required output

Thanks

[vizAlter · Accepted solution]

Hi @JDong — Now, please try this expression in a Formula tool:

Trim(REGEX_Replace([Field1], "^[\d+.,-]+\s", ""))

If it resolves your query Please mark it "Solved" or "Solved" with a Like. This will help other users find the same answer/resolution.  Thank you.

[TerryT]

You could replace anything that is not a letter at the start of the string with an empty string: