+ Reply to Thread
Results 1 to 4 of 4

Find uppercase / capital WORDS in a text

  1. 10-23-2015, 02:39 AM #1
    mils
    mils is offline
    Registered User
    Join Date
    10-16-2012
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    44

    Find uppercase / capital WORDS in a text

    Hi,

    I have column A1 with the following format (this is a short example):

    Can Al SOL 355ml Exp 2014
    Can Al 7UP 330ml STD Vintage 50s 2015
    ZZ_Can Al HEINEKEN Light 500ml 473 US 13
    ZZ_Can Al TECATE 710ml MX 2009
    Can Al SOL 355ml Carnaval 2012
    Can Al HEINEKEN 330ml 4x6 NL 1508
    ZZ_Can Al CARTA BLANCA Light 355ml 2010
    Can Al CARTA BLANCA 355ml CL/CO 2012
    Can Al STRONGBOW Red Berries 400BG/GR/RO


    and I would like to identify any uppercase words (at least more that 3 letters) and create a new column called Brand:

    Brands

    SOL
    7UP
    HEINEKEN
    TECATE
    SOL
    HEINEKEN
    CARTA BLANCA
    CARTA BLANCA
    STRONGBOW


    Thanks for your help.
    Reply With QuoteRegister To Reply
  2. 10-23-2015, 02:50 AM #2
    samba_ravi
    samba_ravi is online now
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,939

    Re: Find uppercase / capital WORDS in a text

    In the above Example All the resultCan Al SOL 355ml Exp 2014

    Can Al 7UP 330ml STD Vintage 50s 2015
    ZZ_Can Al HEINEKEN Light 500ml 473 US 13
    ZZ_Can Al TECATE 710ml MX 2009
    Can Al SOL 355ml Carnaval 2012
    Can Al HEINEKEN 330ml 4x6 NL 1508
    ZZ_Can Al CARTA BLANCA Light 355ml 2010
    Can Al CARTA BLANCA 355ml CL/CO 2012
    Can Al STRONGBOW Red Berries 400BG/GR/RO
    s were 3rd word - Is it always like that only
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 10-23-2015, 03:19 AM #3
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,647

    Re: Find uppercase / capital WORDS in a text

    Continue here:
    http://www.excelforum.com/excel-gene...extracted.html
    should be easier for helpers to follow with whole picture. I am still waiting for your feedback there.
    Quang PT
    Reply With QuoteRegister To Reply
  4. 10-23-2015, 03:52 AM #4
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Find uppercase / capital WORDS in a text

    Ah. A shame that you've decided to "cross-post" without informing anyone.

    Can you please re-read the forum rules on this issue?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make only first letter at first words to be uppercase, other words is lowercase
    By basketmen in forum Excel General
    Replies: 7
    Last Post: 06-05-2014, 02:50 AM
  2. extract capital words and bracket them
    By Hoonjin in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-16-2013, 02:45 AM
  3. Find & Replace: How to find abbreviations or words written in capital words in text
    By neo4u44 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2012, 06:38 AM
  4. excel search text, find non-match words from list, display nonmatch words
    By lgoans in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2012, 07:15 PM
  5. Extract Capital Words
    By agf12555 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2011, 10:15 PM
  6. Macro to change all column headers to Uppercase (i.e. CAPITAL) letters.
    By robertguy in forum Excel General
    Replies: 3
    Last Post: 12-08-2010, 09:36 AM
  7. How to find position of capital letter in a text string?
    By hegisin in forum Excel General
    Replies: 7
    Last Post: 02-19-2007, 12:17 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1