How do I get cells in Excel that contain IP addresses to sort properly?

-------------------------------------------------------------------------------
Become or hire the top 3% of the developers on Toptal https://topt.al/25cXVn
-------------------------------------------------------------------------------

Music by Eric Matyas
https://www.soundimage.org
Track title: Over a Mysterious Island Looping

--

Chapters
00:00 Question
00:53 Accepted answer (Score 42)
02:11 Answer 2 (Score 11)
03:24 Answer 3 (Score 9)
04:26 Answer 4 (Score 8)
05:06 Thank you

--

Full question
https://superuser.com/questions/1279686/...

Question links:
[image]: https://i.stack.imgur.com/Vyqdd.png
[image]: https://i.stack.imgur.com/uaql8.png

--

Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...

--

Tags
#microsoftexcel #ipaddress #sorting

#avk47