| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I extract part of a text in a cell?
I am copying option information from the CBOE website, which contains a
string of characters identifying the option expiry date, strike price, and ticker symbol (e.g. 07 Jul 55.00 (BZHSK-E). I would like to pull out the 55.00 If each string value is always laid out as you showed it... year<spacemonth<spaceprice<spacesymbol then you can use Split to get at the piece you want. For example... InfoLine = "07 Jul 55.00 (BZHSK-E)" Price = Split(InfoLine)(2) Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract part of a cell | Excel Worksheet Functions | |||
| Extract part of a text string | Excel Worksheet Functions | |||
| How do I extract part of a text string | Excel Discussion (Misc queries) | |||
| Extract just numeric part of mixed text/number entry? | Excel Worksheet Functions | |||
| Is there a function to extract the URL part of a hyperlink in another cell? | Excel Worksheet Functions | |||
Threaded Mode
