0

Does anyone know how to do this?

Here's an example:

煒靈工程 Welling Engineering Group

I'd like a formula to just strip out the English....

Can this even be done?

1 Answer 1

0

=REGEXREPLACE(A1,"[^A-Z a-z]+","")


snapshot

1
  • Amazing thanks so much - works great
    – Henry
    May 6 at 3:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.