IP Address database

[maximo1970]

I'm creating a database that will contain IP addresses, firstly is there a way of masking the entry ie 192.168.1.254, I've tried ###.###.###.### but I need some zero's which doesn't help.

Secondly I need to get the last section of the IP address, x.x.x.254, is there a way of doing this.

Thanks for all your help in advance.

Cheers

 

[DougP]

the "Right" function will get the right side of a string as many characters you specify.
=Right(your data,3)
look it up in the VBA help

also "Instr" function will find an occurance of a character such as the period

x=instr(1,yourdata,".&quot
also in help file

will return a 4 for the first period you can loop through and find them all.

DougP, MCP