Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Latitude and Longitude as two columns

Posted on 2013-12-14
2
Medium Priority
?
252 Views
Last Modified: 2013-12-14
In column B I have longitude and latitude data in the following form:

33.394956,-117.593913

In column C. I want just the longitude (the part before the comma not including the comma).

In column D I want just the latitude (the part after the comma, not including the comma).

Any ideas?

Thanks!
0
Comment
Question by:cansevin
2 Comments
 
LVL 12

Accepted Solution

by:
Gregory Miller earned 2000 total points
ID: 39719296
Column C:   =LEFT($B1,SEARCH(",",$B1,1)-1)
Column D:   =RIGHT($B1,LEN($B1)-SEARCH(",",$B1,1))
0
 

Author Closing Comment

by:cansevin
ID: 39719299
Thanks!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question