Hacker News new | ask | show | jobs
by vangelis 1405 days ago
Google Sheets REGEX* and QUERY kick ass. I don't want to use PowerQuery, I want to use formulas.
2 comments
bbkane 1405 days ago
If only Google Sheets let you name cells and ranges!
link
onlyrealcuzzo 1405 days ago
Wait. Can't you name ranges in Sheets??
link
hwayne 1405 days ago
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.)
link
oxfeed65261 1405 days ago
I use regular expressions all the time in Excel, with the relevant functions implemented in VBA.
link