Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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
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,".+:(.+)"))))
