guthrie
04-03-2009, 10:42 AM
I want to do some simple name decoding,
exactly like:
kb/getarticle.php?kb_id=68
But the download link on that page gives me a broken file.
How do I enable regular expressions in Excel 2007,
and perhaps a simple example of decoding a "Last, First M." name?
I expected to do something like:
=regex.execute(A23, "\w+, (\w) .*")
directly in a cell, not writing a VB function.
I saw some VB utility plugins like "regMatch", are those what is needed?
Microsoft site search for "excel regular expressions" gives nothing (!?).
I did enable the regular expressions add-in in VBA from Excel, and thought this should make the functions available in spreadsheet cells, but not so far...
exactly like:
kb/getarticle.php?kb_id=68
But the download link on that page gives me a broken file.
How do I enable regular expressions in Excel 2007,
and perhaps a simple example of decoding a "Last, First M." name?
I expected to do something like:
=regex.execute(A23, "\w+, (\w) .*")
directly in a cell, not writing a VB function.
I saw some VB utility plugins like "regMatch", are those what is needed?
Microsoft site search for "excel regular expressions" gives nothing (!?).
I did enable the regular expressions add-in in VBA from Excel, and thought this should make the functions available in spreadsheet cells, but not so far...