IP address extraction

[Ninja2k]

As an example I have the following in A1

8.8.8.8 % This is the IP address
55.55.55.55 % This is the IP address
100.100.100.100 % This is the IP address

In B1, B2, B3 I need a formula that searches for the string "% This is the IP address" and returns the IP address. My output should be
8.8.8.8
55.55.55.55
100.100.100.100

Anyone know how I could do this?

 

[Kerryx]

Is this
8.8.8.8 % This is the IP address
55.55.55.55 % This is the IP address
100.100.100.100 % This is the IP address
all in cell A1
or in cells a1:a3

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Kerryx]

Book1
	A	B
1	8.8.8.8 % This is the IP address	8.8.8.8
2	55.55.55.55 % This is the IP address	55.55.55.55
3	100.100.100.100 % This is the IP address	100.100.100.100
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=LEFT(A1,FIND("%",A1)-1)