4

Any expert on Google Sheets Regular expressions? I am trying to extract all the text after the last two dots symbol found :

Example on the text= Roger : Blue Large : pack : high brand the word that I need is high brand but I can find I way to match that pattern with the regex function.

Any help would be appreciated!

Feel free to make a copy out of the template below.enter link description here

1 Answer 1

2

You can try with this in B2:

=INDEX(IFNA(REGEXEXTRACT(A2:A,".+: (.+)")))

If you're afraid some time there could be no space after the two dots:

=INDEX(IFNA(TRIM(REGEXEXTRACT(A2:A,".+:(.+)"))))
3
  • Thank you so much! it worked perfectly!
    – Gilbert
    Commented Jan 17, 2023 at 2:39
  • 1
    I'm glad it was useful! Consider marking the question as answered 😉
    – Martín
    Commented Jan 17, 2023 at 2:50
  • hey Martin, could you help me once more with this one? I am still learning about Regex. webapps.stackexchange.com/questions/168825/…
    – Gilbert
    Commented Jan 19, 2023 at 1:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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