How to split text from rows to different collumns ?

How about this:

1. Open your Excel file and select the data range you want to work with.
2. Use the Text to Columns feature:
   • Select the column that contains your data.
   • Go to the Data tab on the Ribbon.
   • Click on Text to Columns.
   • Choose Delimited and click Next.
   • Select the delimiter that separates your data (e.g., comma, space) and click Next.
   • Choose the destination where you want the separated data to appear and click Finish.
3. Extract Latitude and Longitude:
   • If your latitude and longitude coordinates are at the end of each row, you can use the RIGHT and LEFT functions to extract them.
   • For example, if your coordinates are in column A, you can use:

     =RIGHT(A1, LEN(A1) - FIND(",", A1) - 1) 

      

to extract the longitude, assuming the coordinates are separated by a comma.

1. Sort the Data:
   • Once you have the latitude and longitude in separate columns, you can sort the data by selecting the columns and using the Sort feature under the Data tab.