Text

  • Thread starter Thread starter Kieran
  • Start date Start date
K

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!!
 
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.
 
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)
 
More than 1 "." changes things. Assuming 3 ".", then use:

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

HTH
Jason
Atlanta, GA
 
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.





.
Click to expand...
 
Back
Top