I have a firewall log that shows the source IP address with a port number in format like the following:
<ip address:port number>
The length of the digits in the IP address can be from 192.168.0.1 to 192.168.0.254
The port can be anyway from 3 to 4 digits long.
I view the log in my Excel spreadsheet with one column the data. I want to be able to take out the ":port number" and just show the IP address .
Is this possible?