| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove digits after colon
how to parse list of IPs and delete all digits after the colon (include
":" )? have: 121.12.249.207:1080 187.4.205.153:1080 188.193.79.13:17040 222.174.72.38:1080 need parse and get just IP list, without ":1080", .i.e. 121.12.249.207 187.4.205.153 188.193.79.13 222.174.72.38 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to change colon to semi-colon in CP/List Seprator | Excel Discussion (Misc queries) | |||
| Remove all but the last seven digits in a cell | Excel Discussion (Misc queries) | |||
| Formula amendment to not remove digits | Excel Worksheet Functions | |||
| remove and replace digits from a number | Excel Worksheet Functions | |||
| Remove ' if not followed by two digits | Excel Programming | |||
Threaded Mode
