+ Reply to Thread
Results 1 to 3 of 3

Function extract the uppercase letters from strings of text

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2007
    Posts
    7

    Function extract the uppercase letters from strings of text

    Hello,

    I need to extract the uppercase words from strings of text.

    Example: Assortment or Count Change Case
    Needed result: ACCC


    Thank you!!!

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,347

    Re: Function extract the uppercase letters from strings of text

    Hi Hellga,
    try this UDF
    Please Login or Register  to view this content.
    formula on the sheet will look like this
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-29-2013
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Function extract the uppercase letters from strings of text

    Thank you, Nilem!
    It works fine!

+ 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. Replies: 13
    Last Post: 07-08-2012, 11:26 PM
  2. Replies: 4
    Last Post: 06-21-2012, 08:17 PM
  3. Extract text strings
    By wazing in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-22-2010, 01:25 PM
  4. extract text strings
    By jhelliar in forum Excel General
    Replies: 5
    Last Post: 09-16-2008, 12:19 PM
  5. cell entry restricted to text, 2-3 letters & uppercase
    By whitSC in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2007, 03:30 PM

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