Latitude and Longitude as two columns

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!
cansevinAsked:
Who is Participating?
 
Gregory MillerGeneral ManagerCommented:
Column C:   =LEFT($B1,SEARCH(",",$B1,1)-1)
Column D:   =RIGHT($B1,LEN($B1)-SEARCH(",",$B1,1))
0
 
cansevinAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.