I have a column in Sharepoint containing IP-addresses. I can't figure out how to sort them correctly.
They are being sorted like this:
The only "solution" I can find was this thread:
However, I have tried the formula suggestions and they simply don't work correctly. I have tried by using two columns with a formula each and by using one column with the combined formula:
=LEFT([Internal IP];7)&RIGHT([Internal IP];3)
It seems silly to me that sorting numbers would be such a hassle. Have I missed something?