Microsoft Excel - IP address validation in Excel

Asked By Abhijeet Alone on 15-Jan-10 05:10 AM

Hi,

I want to restrict values in a cell in such a way that, only valid IP addresses can be entered.

I have read a solution on the same site, but it does not work properly.

Regards,

Abhijeet

re - IP address validation in Excel - DL M replied to Abhijeet Alone on 15-Jan-10 05:16 AM

IP address validation in Excel - mv ark replied to Abhijeet Alone on 15-Jan-10 05:31 AM

Try this formula with the Data Validation option in the Data menu -
=AND((LEN(A1)-LEN(SUBSTITUTE(A1,".","")))=3,ISNUMBER(SUBSTITUTE(A1,".","")+0))

Choose Custom from the Validation Criteria dropdown in the
Data Validation dialog box

Source:
http://www.mrexcel.com/forum/showthread.php?t=25998