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.