Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Add a temporary column for additional calculations.

Enter the formula

=SUBSTITUTE(SUBSTITUTE(<first source cell>;" ";"");"-";"")

Sort the entire region from the values ​​of the auxiliary column.

Delete the temporary column

Sort Without Spaces

Add a temporary column for additional calculations.

Enter the formula

=SUBSTITUTE(SUBSTITUTE(<first source cell>;" ";"");"-";"")

Multiply the formula to all cells of the sorted column.

Sort the entire region from the values ​​of the auxiliary column.

Delete the temporary column

Sort Without Spaces