4 ms·
Google Sheets REGEX* and QUERY kick ass. I don't want to use PowerQuery, I want to use formulas.
by vangelis 4y ago
Google Sheets REGEX* and QUERY kick ass. I don't want to use PowerQuery, I want to use formulas.
- bbkane 4y agoIf only Google Sheets let you name cells and ranges!
- onlyrealcuzzo 4y agoWait. Can't you name ranges in Sheets??
- hwayne 4y agoYou 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.)
- oxfeed65261 4y agoI use regular expressions all the time in Excel, with the relevant functions implemented in VBA.