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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Gregory MillerConnect With a Mentor General ManagerCommented:
Column C:   =LEFT($B1,SEARCH(",",$B1,1)-1)
Column D:   =RIGHT($B1,LEN($B1)-SEARCH(",",$B1,1))
0
 
cansevinAuthor Commented:
Thanks!
0
All Courses

From novice to tech pro — start learning today.