Excel: Revision history

Jump to: navigation, search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

27 August 2024

  • curprev 00:1400:14, 27 August 2024Ardika Sulistija talk contribs 2,384 bytes +2,384 Created page with "====Sort a Table by IP Address==== ---- #. Create a new column to the left of the <b>IP Address</b> column. Let's call it the <b>Sorted</b> column #. Copy the IP addresses from the <b>IP Address column</b> to the new column (<b>Sorted</b>) #. In the <b>Sorted</b> column, use the "find and replace" feature to remove the first three octets so that you are left with the last octet only ##. For example, it the IP addresses are "10.240.5.4", then find "10.240.5." and replace..."