This helps, thank you.

--------


"Pete_UK" wrote in message
...
You can use this formula in B1:

=LEFT(A1,SEARCH(":",A1)-1)

assuming your first number is in A1, and then copy the formula down.
Fix the values and then delete column A.

Alternatively, you can highlight column A and click on Data | Text-to-
columns, choose delimited on the first panel and colon as the
delimiter on the second panel. Click Finish, then delete column B.

Hope this helps.

Pete


On Jul 26, 11:05 am, "astral"
wrote:
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