View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
astral astral is offline
external usenet poster
 
Posts: 3
Default 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