+ Reply to Thread
Results 1 to 3 of 3

Removing Uppercase phrases longer then 3 letters.

  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    Removing Uppercase phrases longer then 3 letters.

    I need to remove uppercase phrases from my text where the phrase contains more than 3 characters. The macro would search through and delete such instances.

    For example it would find the phrases

    HELLO
    OPEN
    MUSIC BEGINS
    MUSIC STARTS
    AUDIENCE APPLAUD

    and delete them.

    It would ignore

    ABC
    TOE
    RED

    and so on.

    Can someone suggest some Word VBA code to satisfy this?

    Grateful for any advice

    Last edited by CDandVinyl; 04-03-2022 at 11:28 PM.
    Using Excel , Word and Access 2003 - For the whole of 2024

  2. #2
    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: Removing Uppercase phrases longer then 3 letters.

    Try:
    Please Login or Register  to view this content.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    Re: Removing Uppercase phrases longer then 3 letters.

    Many thanks - this works perfectly. I'm grateful.


+ 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. [SOLVED] Code no longer working in Excel 2016 for convert text to uppercase
    By dj_mix in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-13-2018, 11:07 AM
  2. [SOLVED] Removing duplicate phrases from corresponding columns
    By probuddha in forum Excel General
    Replies: 6
    Last Post: 06-20-2016, 04:02 PM
  3. [SOLVED] Find the first two Uppercase letters in a string and return that value
    By CrazyPerson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2016, 03:40 PM
  4. [SOLVED] VBA Code for Uppercase or Lowercase letters
    By gbloemke in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-26-2014, 10:37 AM
  5. Changing Uppercase letters to lowercase
    By tubells in forum Excel General
    Replies: 4
    Last Post: 03-17-2010, 02:12 PM
  6. VB - Making first letters of words uppercase
    By Smurlos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-05-2010, 08:10 PM
  7. [SOLVED] CHANGE WHOLE EXCEL worksheet TO UPPERCASE LETTERS?
    By mineralgirl in forum Excel General
    Replies: 4
    Last Post: 09-02-2005, 09:05 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