SPACES

Hello Zara,

Thank you for your question.

1. If you're referring to empty columns between data cells/ranges, select the columns along their headers and press delete.

If you're referring to random patterns of empty cells/ranges between data cells/ranges, it's best to select and drag existing data cells/ranges closer to other data cells/ranges using the mouse.

If you're referring to spaces between characters inside cells, you can do one of two things:

a. Use the =TRIM function to remove spaces before and after a string and all but one space inside strings.

b. Use Replace to remove all spaces in cells. In 'Find what' type one space and in 'Replace with' type nothing.

2. To sort by last digits, insert a new column next to the IP column. In the new column, next to the first IP address, type the digits after the last decimal point of that IP address.

Enter this and click back on the cell you typed in. Then, in the Home tab, click the Fill button (in the Editing group), then click Flash Fill. This will fill all the digits after the last decimals down the column.

When you sort this new column, it will sort all columns in the table.

I hope this helps.

Kind regards
Marius Barnard
STL