converte a lat,long cell into two separate cells

**jmgoodha** · 02-28-2015, 05:47 PM

Hi everyone!
I'm making a spreadsheet to convert it to ArcGIS. So I have a column with latitude and longitude information. Is there a way to separate these into two different columns without having to copy and paste each longitude into a new cell? I have hundreds of cells formulated like this, so it would take quite a bit of time.
Thanks for the help!!

**FDibbins** · 02-28-2015, 06:09 PM

Hi, welcome to the forum

Probably, but it would help if you showed some sample data?

**ibt** · 02-28-2015, 09:57 PM

Not sure what the data looks like, but if it was entered into cell A2 as:
38°53'23"N , 77°00'27"W
Then you could do:
=LEFT(A2,SEARCH(",",A2)-1) in cell B2
and
=MID(A2,SEARCH(",",A2)+1,20) in cell C2

Hope that helps...