Sorting by the last IP address in EXCEL

 

In EXCEL, IP addresses are listed in the column. How do I sort IP addresses by the last bit ?? (The first three digits are the same)

IP address format: 192.168.1.XXX

After direct sorting, the effect is:

192.168.1.1

192.168.1.10

192.168.1.11

.....

192.168.1.2

192.168.1.20

.....

Expected results:

192.168.1.1

192.168.1.2

192.168.1.3

.....

 

Where can I set this ??

Secondary columns can be sorted as follows:

 

Data in column

Input in b1

= Mid (a1, 11,3)

Push-down

Then take Column B

Column a is lined up

From: waiting for a blog