Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Get rid of with regular expressions

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,651
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regular expressions in VB FiluDlidu Excel Discussion (Misc queries) 4 March 21st 08 01:10 AM
Regular Expressions & Middle Name [email protected] Excel Worksheet Functions 7 July 22nd 07 01:58 AM
VB Script Regular Expressions - Missing John Taylor Excel Discussion (Misc queries) 2 August 17th 06 12:32 PM
Substring in excel? How about regular expressions? Samuel Excel Discussion (Misc queries) 8 May 22nd 06 04:43 PM
Regular expressions in Excel vigi98 Excel Discussion (Misc queries) 3 November 10th 05 04:40 PM


All times are GMT +1. The time now is 07:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"