Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On a Form I have a Combo Box that lists values like this
1.2.3.4 10.11.12.13 90.121.92.93 where the "." periods are my delimiter I want to extract only the 1st two octets and write them to a worksheet. What code could I use to extract based on a delimiter? For example if I pick the 1st example in my list, the 1.2 would be extracted and set as the value to write to my worksheet. If the 2nd example was chosen, 10.11 would be written. Any Ideas? Jody |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract info based on Name | Excel Discussion (Misc queries) | |||
extract names based on conditions | Excel Discussion (Misc queries) | |||
How to extract multiple cells based on one value | Excel Worksheet Functions | |||
how to extract data based on date | Excel Worksheet Functions | |||
Extract row based on a criteria | Excel Programming |