Timeline for Function to return a string legal for a range name
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 6, 2016 at 19:51 | comment | added | AlexR | @JeremyCaron That's too bad. There is a SO question on RegEx for Excel on Mac, maybe this can help you out: stackoverflow.com/questions/27344932/… | |
| Feb 6, 2016 at 16:24 | comment | added | Jeremy Caron |
I'm using Excel for Mac 2011 and it looks like VBScript.RegExp isn't natively supported on Macs (...regret). I'm seeing some discussion around writing the regular expression in Perl and handling the I/O with this method. I'll look into it, but I have a sinking feeling I'd be getting way over my head with this. Thank you for the suggestion though. This does seem to be the ideal way to do it.
|
|
| Feb 6, 2016 at 16:13 | history | edited | AlexR | CC BY-SA 3.0 |
added 668 characters in body
|
| Feb 6, 2016 at 16:00 | comment | added | AlexR |
Taking a look at the specs for character classes I found the legal characters are precisely \w, so we can even use \W for the illegal ones.
|
|
| Feb 6, 2016 at 16:00 | history | edited | AlexR | CC BY-SA 3.0 |
deleted 11 characters in body
|
| Feb 6, 2016 at 15:59 | comment | added | Mathieu Guindon | Ah! I was hoping for someone to come along and mention regular expressions! | |
| Feb 6, 2016 at 15:56 | history | answered | AlexR | CC BY-SA 3.0 |