How to sort

[jjblackisback]

Each line below is in a cell. I would like to sort the cells by Thunnel##. ip route 172.21.3.0 255.255.255.0 Tunnel28 220

ip route 172.21.4.0 255.255.255.0 Tunnel81 220

ip route 172.21.19.0 255.255.255.0 Tunnel47 220

ip route 172.21.20.0 255.255.252.0 Tunnel8 220

ip route 172.21.25.0 255.255.255.0 Tunnel60 220

ip route 172.21.26.0 255.255.255.0 Tunnel60 220 any ideals?

<colgroup><col></colgroup><tbody>
</tbody>

 

[Son]

One way, not sure if it's the best, would be to use a helper column to extract the Tunnelxx value and then sort using that column. Another way would be to do this using a macro, which would then clear the contents of the helper column.

 

[JoeMo]

The data in columns E:F have been sorted using the sort column.

Excel Workbook
	A	B	C	D	E	F
1	Data	Sort Col			Data	Sort Col
2	ip route 172.21.3.0 255.255.255.0 Tunnel28 220	Tunnel28 220			ip route 172.21.3.0 255.255.255.0 Tunnel28 220	Tunnel28 220
3	ip route 172.21.4.0 255.255.255.0 Tunnel81 220	Tunnel81 220			ip route 172.21.19.0 255.255.255.0 Tunnel47 220	Tunnel47 220
4	ip route 172.21.19.0 255.255.255.0 Tunnel47 220	Tunnel47 220			ip route 172.21.25.0 255.255.255.0 Tunnel60 220	Tunnel60 220
5	ip route 172.21.20.0 255.255.252.0 Tunnel8 220	Tunnel8 220			ip route 172.21.26.0 255.255.255.0 Tunnel60 220	Tunnel60 220
6	ip route 172.21.25.0 255.255.255.0 Tunnel60 220	Tunnel60 220			ip route 172.21.20.0 255.255.252.0 Tunnel8 220	Tunnel8 220
7	ip route 172.21.26.0 255.255.255.0 Tunnel60 220	Tunnel60 220			ip route 172.21.4.0 255.255.255.0 Tunnel81 220	Tunnel81 220
Sheet1

 

[jjblackisback]

The data in columns E:F have been sorted using the sort column.
Sheet1

*	A	B	C	D	E	F
1	Data	Sort Col	*	*	Data	Sort Col
2	ip route 172.21.3.0 255.255.255.0 Tunnel28 220	Tunnel28 220	*	*	ip route 172.21.3.0 255.255.255.0 Tunnel28 220	Tunnel28 220
3	ip route 172.21.4.0 255.255.255.0 Tunnel81 220	Tunnel81 220	*	*	ip route 172.21.19.0 255.255.255.0 Tunnel47 220	Tunnel47 220
4	ip route 172.21.19.0 255.255.255.0 Tunnel47 220	Tunnel47 220	*	*	ip route 172.21.25.0 255.255.255.0 Tunnel60 220	Tunnel60 220
5	ip route 172.21.20.0 255.255.252.0 Tunnel8 220	Tunnel8 220	*	*	ip route 172.21.26.0 255.255.255.0 Tunnel60 220	Tunnel60 220
6	ip route 172.21.25.0 255.255.255.0 Tunnel60 220	Tunnel60 220	*	*	ip route 172.21.20.0 255.255.252.0 Tunnel8 220	Tunnel8 220
7	ip route 172.21.26.0 255.255.255.0 Tunnel60 220	Tunnel60 220	*	*	ip route 172.21.4.0 255.255.255.0 Tunnel81 220	Tunnel81 220

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:304px;"><col style="width:88px;"><col style="width:36px;"><col style="width:37px;"><col style="width:304px;"><col style="width:88px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B2 =RIGHT(A2,LEN(A2)-SEARCH("Tunnel",A2)+1) <tbody> </tbody>

<tbody>
</tbody>

That worked perfect, thank you very much.

 

[JoeMo]

The data in columns E:F have been sorted using the sort column.
Sheet1

*	A	B	C	D	E	F
1	Data	Sort Col	*	*	Data	Sort Col
2	ip route 172.21.3.0 255.255.255.0 Tunnel28 220	Tunnel28 220	*	*	ip route 172.21.3.0 255.255.255.0 Tunnel28 220	Tunnel28 220
3	ip route 172.21.4.0 255.255.255.0 Tunnel81 220	Tunnel81 220	*	*	ip route 172.21.19.0 255.255.255.0 Tunnel47 220	Tunnel47 220
4	ip route 172.21.19.0 255.255.255.0 Tunnel47 220	Tunnel47 220	*	*	ip route 172.21.25.0 255.255.255.0 Tunnel60 220	Tunnel60 220
5	ip route 172.21.20.0 255.255.252.0 Tunnel8 220	Tunnel8 220	*	*	ip route 172.21.26.0 255.255.255.0 Tunnel60 220	Tunnel60 220
6	ip route 172.21.25.0 255.255.255.0 Tunnel60 220	Tunnel60 220	*	*	ip route 172.21.20.0 255.255.252.0 Tunnel8 220	Tunnel8 220
7	ip route 172.21.26.0 255.255.255.0 Tunnel60 220	Tunnel60 220	*	*	ip route 172.21.4.0 255.255.255.0 Tunnel81 220	Tunnel81 220

<tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B2 =RIGHT(A2,LEN(A2)-SEARCH("Tunnel",A2)+1) <tbody> </tbody>

<tbody>
</tbody>

That worked perfect, thank you very much.

You are welcome - thanks for the reply.