+ Reply to Thread
Results 1 to 5 of 5

Find & Replace: How to find abbreviations or words written in capital words in text

  1. #1
    Registered User
    Join Date
    01-31-2011
    Location
    Islamabad, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    23

    Find & Replace: How to find abbreviations or words written in capital words in text

    I wanted to find all abbreviations in my thesis. So I think if I can find [B]a command for find and replace which returns all capital letter words in the text as highlighted [/B]then I can easily browse through the text to check which abbreviations I have used. I tried to play with wildcards in MS Word, but they are way out of my league.

    I am using MS Word 2007.

    Looking forward to your kind help.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Find & Replace: How to find abbreviations or words written in capital words in text

    Ensure Use Wildcards is checked on the Find dialog and then use this reg expression.

    (<[A-Z][A-Z0-9]{1,100}>)

    Should find words that are 2 to 101 characters in length. All upper case but can contain numbers. First characters is Letter A thru Z.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-31-2011
    Location
    Islamabad, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Find & Replace: How to find abbreviations or words written in capital words in text

    Dear Andy Pope

    Thank you very much for your reply. If I want to find only letters than should I use it like this
    (<[A-Z]{1,100}>) and also what should I write in the replace box. Should I use the same expression with selecting highlight from format?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Find & Replace: How to find abbreviations or words written in capital words in text

    You would need to research regular expression, I no expert in that field.

    What would you replace any finds you locate with? Are you just reverting to lowercase?

  5. #5
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Find & Replace: How to find abbreviations or words written in capital words in text

    Hi Neo4u44,

    Use a wildcard Find, where:
    Find = <[A-Z]{2,}
    The '2' tells word to ignore single-letter capital words like 'A', 'I', etc.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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