ExcelBanter - convert IP address to XXX.XXX.XXX.XXX

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - convert IP address to XXX.XXX.XXX.XXX (https://www.excelbanter.com/excel-programming/318126-convert-ip-address-xxx-xxx-xxx-xxx.html)

AVBBEN

convert IP address to XXX.XXX.XXX.XXX

I need to convert a list of ~1000 IP address to XXX.XXX.XXX.XXX format in
order to sort them. Can anyone help?

All times are GMT +1. The time now is 08:36 AM.