Results 1 to 5 of 5

Extract UPPER CASE words.

Threaded View

  1. #1
    Forum Contributor excelkeechak's Avatar
    Join Date
    07-21-2008
    Location
    India.
    MS-Off Ver
    2013 /2016
    Posts
    363

    Extract UPPER CASE words.

    i had a scenario in which i need to extract only the UPPER case words from a column and paste them in the adjacent column. Is there any formula or vba routine for it.

    Ex:
    COL A contains the following:
    FIRST
    second
    THIRD
    FOURTH
    fifth
    sixth
    SEVENTH

    ......and so on.

    i need to extract only the Letters or words which are in total Uppercase and paste them in the next column ..i.e. COLUMN B..

    any forumlas...
    Last edited by excelkeechak; 07-29-2009 at 09:27 PM.
    THANKS
    ExcelKeechak

Thread Information

Users Browsing this Thread

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

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