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
  • 985
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.8k
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,000

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