+ Reply to Thread
Results 1 to 4 of 4

Replace Parenthesized Phrase with Wildcard

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Replace Parenthesized Phrase with Wildcard

    I have a document which has 137 instances of "(X of 137)", where X is a number from 1 to 137. I want to remove all instances, and thought to do it through REPLACE (replacing with nothing). But I can't figure out how to use a wildcard for X. I've turned on "use Wildcards" in my Replace dialogue, and I've tried "(* of 137)", "([*] of 137)". Not sure what else to do. Any help is appreciated.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Replace Parenthesized Phrase with Wildcard

    Use this:

    \(* of 137\)

    When you have selected Use Wildcards, the () are special characters used for the wildcard language, and so if you want to include them in your actual text you must escape them with a "\".
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,952

    Re: Replace Parenthesized Phrase with Wildcard

    6StringJazzer,
    You did it! Thank you so much, for the solution, and for the explanation!

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Replace Parenthesized Phrase with Wildcard

    You're welcome, and thanks for the rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using Replace() to search for a two-word phrase
    By jpcsolutions in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-09-2015, 02:25 PM
  2. [SOLVED] Find: Using wildcard, but don't replace with wildcard
    By JimDandy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-06-2013, 05:39 PM
  3. Subsitute or Find/Replace words in a phrase
    By Crhodes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2013, 09:13 PM
  4. Replace Hyperlink with a phrase.
    By searches in forum Excel General
    Replies: 2
    Last Post: 04-10-2012, 02:05 PM
  5. Replies: 3
    Last Post: 03-30-2012, 11:19 AM
  6. Replace Wildcard with Same Character
    By jmeggers in forum Excel General
    Replies: 6
    Last Post: 10-11-2011, 09:28 PM
  7. Wildcard Find and Replace
    By DaveSmith2020 in forum Excel General
    Replies: 5
    Last Post: 02-16-2009, 12:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1