Extract text from a cell

[doug.j.g]

I am trying to extract some text from a cell, it is in the form of an i
address, ie 10.33.4.57 and want to extract the first three octects o
the number. The number can be a variable length with each octe
containing one, two or three charcters.

Dou

 

[RNR]

If you are trying to extract fixed length characters(say 3 charaters
from A1) then "=left(a1,3)" would work...

 

[Haldun Alay]

Hi,

Assume that cell A1 has IP number, enter cell B1 following formula.

=MID(SUBSTITUTE(A1,".","@",3),1,SEARCH("@",SUBSTITUTE(A1,".","@",3))-1)

results
A1->10.33.4.57
B1->10.33.4


Kind regards.

--
Haldun Alay

"doug.j.g >" <<[email protected]>, iletide þunu yazdý I am trying to extract some text from a cell, it is in the form of an ip
address, ie 10.33.4.57 and want to extract the first three octects of
the number. The number can be a variable length with each octet
containing one, two or three charcters.

Doug

 

[Bob Phillips]

Doug,

Try Data>Text to Columns with dot(.) as a delimiter, this will put each
octet into separate cells.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)