ExcelBanter - Get rid of with regular expressions

On Mon, 18 Jan 2010 10:49:01 -0800, Howdy
wrote:

I used to get rid of leading or with Regular Expressions in Word 2003.
Why can I NOT do that in Word 2007?

Thank you in advance.

You might be better of asking that question in a Word newsgroup, rather than an
Excel newsgroup.

Neither Excel 2003 nor Excel 2007 have native implementation of Regular
Expressions. However, in both support for Regular Expressions can be added
using VBA programming.

In Word 2007, you can use a sort of Regular Expression in the FIND & REPLACE
dialog by selecting the "use wildcards" option. BUT, if you have the "use
wildcards" option enabled, then any token which could be a wildcard, must be
preceded by a "\" to be interpreted literally.

So either use as your search string with wildcards not enabled, or, if
wildcards are enabled, use \\

--ron