split lat and long from one coloum into two

[valhalla1]

I have a coloum with lat and long coordinates like this 54 29.6310 / -117 57.0350

Is there a way i can split the coloum so it creates two coloums with 54 29.6310 and -117 57.0350

I attached the spreadsheet im working with, thank you for any help.

[Haseeb Avarakkan]

Hello valhalla1, Welcome to the forum.

Insert a column after column C, so now Column D data will be in column E, then select Column C, go to

Data >> text to columns,select Delimited, click next
On the left side select Other & type / in the right side white box

Click finish. Now the data will be in two columns.

[valhalla1]

Hello valhalla1, Welcome to the forum.

Insert a column after column C, so now Column D data will be in column E, then select Column C, go to

Data >> text to columns,select Delimited, click next
On the left side select Other & type / in the right side white box

Click finish. Now the data will be in two columns.

You absolutly rock!!! thank you! this forum is awsome

[valhalla1]

I have one other question. When i divide my data into two coloums i get a space before the '-' sign. Is there a way to eliminate this? thank you

[Haseeb Avarakkan]

Glad to hear it works. if you are satisfied with solution, please mark your thread as SOLVED. for doing this,

- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

[Haseeb Avarakkan]

Select the column, press CTRL+H,

Find What: [space]-
Replace with a "-" (without quotes)

[space] is not a text hit space bar,

click Replace All

[valhalla1]

Solved,

Thank you!