Remove last octet using excel formula


I have a list of IP's in column A1 and I want to remove the last octet and display up to the 3rd octet in column B1.

(example...10.50.42 instead of
LVL 19
Edward PamiasTeam Lead RRS DeskAsked:
Who is Participating?
AlanConnect With a Mentor ConsultantCommented:

If the full IP address is in A1, use this in B1 and copy down as far as required:



Edward PamiasTeam Lead RRS DeskAuthor Commented:
This is perfect! Thanks!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.