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
Bookmarks