Skip to main content
Share Your Experience: Take the 2024 Developer Survey
2 votes
Accepted

Regexextract to get a text in the middle of string

Using a capturing group, we can match a pattern then choose which part of the pattern we want to return. =ArrayFormula(REGEXEXTRACT(A2:A4,"^\d\s+(\w\d+\s+-\s+[A-z 0-9]+)")) Notes: I'm ...
David Tan's user avatar
  • 1,005
1 vote

Combine two formulas for multiple inputs

Since your first formula works with both of the examples you provided, I believe you want to get the same results with your second formula as well. In this case, just change it as follows: =...
Daniele's user avatar
  • 2,428
1 vote
Accepted

Use Regular Expressions to Add Text to Beginning or End of Cells

How to Add Text to Beginning or End of Cells without a formula Please follow these steps Step 1 Go to the top menu --> Edit --> Find and replace Step 2 From Search choose Specific range and ...
marikamitsos's user avatar
  • 12.9k
1 vote

Searching a list and replacing value if any item matches any item in the other list in Google Sheets

Try REGEXPLACE instead : =REGEXREPLACE([source value],TEXTJOIN("|",TRUE,'list of values to look for the source value in'!A:A),"static string")
pjmg's user avatar
  • 2,010

Only top scored, non community-wiki answers of a minimum length are eligible