Excel Trick for Sorting Problem With Numbers As Text. Step by Step discussion.
Excel Trick for Sorting Problem With Numbers As Text. Step by Step discussion.
The final formula created is given below to copy paste -
=VALUE(LEFT(A1,FIND(" ",A1)-1))