Questions tagged [regexextract]

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

13 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1 vote
1 answer
9 views

Remove middle part of string?

I have managed to an extent but need help to get desired output with just 1 formula :) Please see below.
  • 11
1 vote
0 answers
15 views

Why 2 columns of the same value give different total?

Sample Data in Result Sheet I have a formula in A2 that extracts data & splits it into unit & product (A & B). I used the SUMIF formula to give the the total of each separate set of ...
  • 191
1 vote
1 answer
157 views

Using REGEXEXTRACT to retrieve specific content from two separate rows in the same column

I Included a Google Sheets link =REGEXEXTRACT(A2:A3, "19..") To me, it would seem as if this would check both cells for any date starting with 19 and extract that into the cell But, it ...
1 vote
1 answer
113 views

Can I populate Google Sheets cells adjacent to a target cell?

I have a maintenance tracker in Google Sheets for lighting fixtures. One column is a type of fixture "B", the column adjacent is the problem "C". I'd like to find specific fixtures by name and copy ...
0 votes
0 answers
25 views

IMPORTRANGE contains specific columns with multiple answers

Example, one person can enter 5 events with several options for participating (both days or Sunday only or 1st go....) how do I get master1 sheet to only show contestants on Saturday and master2 only ...
0 votes
1 answer
118 views

Extract Data from 2 columns if it matches condition

This is how my main data sheet looks like And for any item that has customization, for e.g. - ORGANIC, I want to extract/copy just those data, the meal name & total units to another sheet. And ...
  • 191
0 votes
1 answer
155 views

I want to get values from multiple URL's in Google Spreadsheet. IMPORTDATA doesnt work

I have 9000 lines with URL's in my Google Sheet. Example: https://steamcommunity.com/auction/ajaxgetgoovalueforitemtype/?appid=233860&item_type=10). Every URL returns JSON like this: { "success": ...
0 votes
1 answer
44 views

How to partial extract from 3 columns with multiple levels of rules?

The formula someone on this forum provided worked well, but I have run into a problem, which I am struggling to get around. Google sheets Link The formula in H2 looks between 00 & 02 and ...
  • 135
-1 votes
1 answer
638 views

How do I use non capturing groups in google sheets?

This is what I intend to do. But a similar one doesn't work. As with any problem I post, I still can't solve it after more than two hours of trying. :-( https://github.com/google/re2/wiki/Syntax
  • 111
-1 votes
1 answer
35 views

How can I extract specific information from the cells?

How can I extract just the: Brand, Showroom Only Product, etc.
  • 1
-1 votes
1 answer
65 views

Inaccurate output when using importrange vs manual input

I have a little problem using Google Sheets. I'm using importrange to get raw data from another sheet that I don't own. This is the sample raw data, then import it my own sheet here. Importing data ...
  • 7
-1 votes
2 answers
114 views

How to move a Google Sheet from one file to another while retaining external references

Background I usually add several sheets to a single Google sheets file. There is always a separate sheet that extracts information from the other sheets (via REGEXEXTRACT etc). Problem sometimes ...
  • 1,119
-1 votes
1 answer
28 views

Multiplying several numbers within a text string, is this possible?

I have cell A1 which is a text string: 100 blue cars, 100 red cars, 100 yellow cars In cell B1 I have a number which is a multiplier say 2. Is it possible to change the numbers within cell A1 ...