| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to extract capitalized group in text string
How would I extract the capitalized, 3 character group from a text string?
I have 283 rows of text of varying lengths, each with a 3 character upper case string imbedded at any point, followed by more characters. I would like to isolate the 3 characters of upper case text and place them in a single column. Some examples a iPath S&P GSCI Crude Oil Tot Ret Idx OIL Specialty - Natural Resources UltraShort Financials ProShares SKF Specialty - Income holdings PowerShares DB Energy DBE Specialty - Healthcare -- newwbie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract text from string | Excel Worksheet Functions | |||
| Extract text from a string | Excel Worksheet Functions | |||
| Extract text from String | Excel Worksheet Functions | |||
| convert capitalized text to small text (with Capitalized names an | Excel Discussion (Misc queries) | |||
| Extract % from text string | Excel Worksheet Functions | |||
Threaded Mode
