Regular expressions for replacements in Excel?
There's a tutorial on the MVPS site. Word's regular expressions are pretty
well the same as any other, except that it uses minimal matching where unix
regex uses maximal.
"Shannon Jacobs" wrote in message
...
Doesn't seem like many people are using the regular expression capability
in
Excel. Some reason? Apart from the fact that it's kind of hard to figure
out? Actually, I'm trying to port some JavaScript regular expressions into
Excel... I think I've enabled the required library linkage, but I can't
seem
to figure out the syntax required to refer to all of the lines in the
spreadsheet (which is really just a list of text strings). Don't seem to
be
any good examples anywhere I can find them on the Web, and the Microsoft
documentation has been typically unenlightening.
Are the examples and useful instructions more liable to be found on the
Word
side? Some of the later manipulations would be better with the
spreadsheet's
capabilities, however.
|