Questions tagged [regexextract]

For questions about a spreadsheet function that allows selection from a string on the basis of a regular expression.

Filter by
Sorted by
Tagged with
5 votes
1 answer

How to apply a relative reference in conditional formatting formula?

I have a whole bunch of cells (28 so far) that need conditional formatting. Here is what the data looks like: I want the colours in the top "Last Period" metric cells to vary depending on the values ...
Drewdavid's user avatar
  • 648
3 votes
2 answers

How can social hashtags be extracted from a cell?

Example: A2 -> What a beautiful day! #sunday #summer B3 -> #news Stay tuned for our next contest! #something Desired output on B2 ->#sunday #summer Desired output on B3 ->#news #...
Renan's user avatar
  • 51
1 vote
1 answer

Pretty print google sheet formula?

Finding answers on Web Apps SE or Reddit is wonderful, but if you don't understand them you can't modify them. I recently came across the following as part of an answer: ={"Corrected List 2";...
Sherwood Botsford's user avatar
3 votes
1 answer

How to categorize data in Google Spreadsheet using regular expressions

I'm trying to categorize some data in a Google spreadsheet. I have "phrases to screen" in column A, TAB "Phrases". For example "blueish house" I have "words" in column A, TAB "Words". For example, "...
G Adams's user avatar
  • 33
3 votes
1 answer

How to modify REGEXEXTRACT to import total hours played on Steam

My problem is similar as the one answered here: How to create an auto updating Google spreadsheet with information from Steam? Only I need to modify the REGEXEXTRACTs to find total hours played ...
tipie's user avatar
  • 31
0 votes
1 answer

How would you find and extract the 2nd ocurrence and extract only the number that is in between =value"123456789"?

Any expert on Google Sheets Regular expressions? I am trying to extract the numbers that exist in the second occurrence of this pattern value="400" from the HTML text that I am sharing in ...
Gilbert's user avatar
  • 39