0

As you can see below I have these data in single cell I want only car nos as my result

enter image description here

1
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it and even upvote it so others can benefit as well. Feb 24, 2021 at 13:19

1 Answer 1

0

Please use

=QUERY(IFERROR(INDEX(REGEXEXTRACT(C2:C;"(\w+) onb")));
         "where Col1<>'' ")

enter image description here

(do adjust ranges and formula according to your locale)

Functions used:

1

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.