-
Notifications
You must be signed in to change notification settings - Fork 0
Regular Expressions
Thach Hoang edited this page Aug 29, 2016
·
3 revisions
- Make a Google spreadsheet, paste newline-separated input in column A.
- In B1, use REGEXEXTRACT with your regex of choice:
=ARRAYFORMULA(REGEXEXTRACT(A1:A, "(Rd|Road|Ln|Ave)")) - BOOM.