Pulling specific information out of excel rows

[cbarr1987]

Howdy

I have a long list of data in a spreadsheet that is in the following format. It is all contained within one column/cell

46.104861,-64.702142,"1080 Champlain St, Dieppe, New Brunswick",-,
44.697439,-63.584861,"121 Ilsley Ave, Dartmouth, Nova Scotia",-,
45.476162,-76.689467,"104 Raglan St N,, Renfrew, Ontario",-,
etc

So its: Latitude, Longitude, "Address, city/state, country"

I need to create a column for latitude and another for longitude. So one formula that will give me the first number in the string, and another formula that will give me the second number after the first comma. For example, the first string should return:

A1:46.104861
B1:-64.702142

Any help is much appreciated!

[cbarr1987]

I found that:

=LEFT(E1,FIND(",",E1)-1)

Yields the first number, but I'm lost on how to get the second

[Ace_XL]

First up ..try

Data -- Text to columns -- Delimited by -- comma.

This will split contents of the cell in differnt columns.

[cbarr1987]

Wow, immediate response and that worked perfectly. And it was simple. Thanks Ace!!