Google Sheets REGEX Challange

by Elad Ratson   Last Updated December 29, 2017 13:03 PM

I have a long Google Sheet column of cells with content looking like this:

#text: Jacob Zuma

#text: World news

#text: ANC (African National Congress)

#text: South Africa

#text: Africa

I need it to look like this:

Jacob Zuma, World news, ANC (African National Congress), South Africa, Africa

Basically, i'm trying to find a way to get rid of all the headers (#[email protected]) and the URLs, and have only the subjects themselves, all lined-up, separated with commas.

Would appreciate help in figuring out how to do it.

Related Questions

REGEXEXTRACT and French accents in Google Spreadsheets

Updated October 01, 2017 06:03 AM

Is there a RegEx-Text-Extraction-as-a-service?

Updated January 12, 2018 21:03 PM

How can I use the capturing group in a function?

Updated September 02, 2018 18:03 PM