Pulling IP Addresses out of log files.

[marksman681]

Hello I am having an issue and need some help. I have some SSH log files in excel. Column C is where the data is. There is a lot of text wrapped around the IP address and I want to be able to pull it out into a different column. The text that is around the IP address is random in length. I do not need anything that is missing an octet but if it grabs it I do not care.

 

[marksman681]

Okay to all I seem to have got the issue figured out. it was a windows thing on my end that is now corrected and it is working as described. Thank you to everyone for the assistance and work in building the formulas.

 

[Fluff]

Glad it's sorted & thanks for the feedback.