Results 1 to 8 of 8

Extract Capitalized Words From String

Threaded View

  1. #1
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Extract Capitalized Words From String

    Hi

    I have these strings in Column B:

    Benzylpenicillin Panpharma pul.t.inj.+inf.,opl.6 mg/ml intravenøst 100 ml kl 00:00 + 100 ml kl 06:00 + 100 ml kl 12:00 + 100 ml kl 18:00
    Digoxin DAK tabletter 62.5 mikg peroralt1 tablet 1 gang(e) Daglig
    Furix tabletter 40 mg peroralt2 tabletter til morgen + 1 tabletter til middag
    Unikalk SIlver tabletter peroralt1 tablet til morgen og til aften
    Ciprofloxacin Fresenius Kabi inf.væske, opløsning 2 mg/ml intravenøst 200 ml kl 08:00 + 200 ml kl 20:00

    I'd like to extract all the Capitalized words in the above strings into Column A such that Column A will reflect this:

    Benzylpenicillin Panpharma
    Digoxin DAK
    Furix
    Unikalk SIlver
    Ciprofloxacin Fresenius Kabi

    I've searched the Web and haven't found any references to this kind of extraction. You're help will be greatly appreciated.

    John
    Last edited by jaslake; 04-12-2010 at 06:39 PM.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

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