3

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

Your Answer

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

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