Text

[Kieran]

How do I return everything left of a "."? I don't want
to include the . but I want everything before it to
show. Can someone help please, driving me mad!!

 

[Andy B]

Hi

Try this:

=LEFT(A1,FIND(".",A1)-1)

 

[Jason Morin]

=LEFT(A1,FIND(".",A1)-1)

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks Jason & Andy,

However, it doesn't seem to work. I have an IP address
of 10.100.128.12. All i want it to return is 10.100.128
but all I get with the formula below is 10.

 

[Andy B]

Ah

Well that's because you didn't say there was more than one . in it!!
Try this:
=LEFT(A1,FIND("^",SUBSTITUTE(A1,".","^",3))-1)

 

[Jason Morin]

More than 1 "." changes things. Assuming 3 ".", then use:

=LEFT(SUBSTITUTE(A1,".","$",3),FIND("$",SUBSTITUTE
(A1,".","$",3))-1)

HTH
Jason
Atlanta, GA

 

[Guest]

Andy, You're a gentleman.

Thank you

-----Original Message-----
Ah

Well that's because you didn't say there was more than one . in it!!
Try this:
=LEFT(A1,FIND("^",SUBSTITUTE(A1,".","^",3))-1)


--
Andy.





.

 

[Andy B]

Thanks for the feedback!!

--
Andy.

Andy, You're a gentleman.

Thank you