If only Google Sheets let you name cells and ranges!
Wait. Can't you name ranges in Sheets??
You can name cells in the upper left corner and name ranges under `Data > Named Ranges`. You can't create a value that's not part of a cell or range (which you can do in Excel under the Name Manager.)
I use regular expressions all the time in Excel, with the relevant functions implemented in VBA.