By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,047 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

Extract Capitalized Words from Text

P: 8
I am trying to extract capitalized words from text in Excel. I have a list of a combination of brands and products and I am trying to extract out the product attribute from the text. Since the text varies in length, I cannot use standard text parsing excel functions to extract the product from the text. I could use text to columns but that gets labor intensive. Is there a way to extract out the capitalized words from text in Excel? How do I extract out "BAKED BAGELS" from "1st National Bagel Co. BAKED BAGELS"?

1st National Bagel Co. BAKED BAGELS
3 Blind Moose DOMESTIC DRY TABLE
3 Diamonds FRUIT CANNED
4 Grain EGGS FRESH
4C BREADING PRODUCTS
4C GRATED
Jul 10 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.