As long as you only want the first section
=LEFT(A1,FIND(".",A1)-1)
On Mon, 31 Jan 2005 22:37:03 -0800, riffmastr
wrote:
I'm trying to remove decimal places from IP addresses (example 24.12.118.76)
in excel so I can treat them as regular numbers. I really just want to use
the beginning part (24). Does anybody know how to convert this to a regular
number?
|