Separate GPS Coordinates

[tzianhao]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Coordinates[/TD]
[TD]Latitude[/TD]
[TD]Longitude[/TD]
[/TR]
[TR]
[TD]3.321151, 101.575798[/TD]
[TD]Formula to Seek Only Before Comma[/TD]
[TD]Formula to Seek only After Comma[/TD]
[/TR]
</tbody>[/TABLE]

Possible ?

 

[Fluff]

How about

Excel 2013/2016
	A	B	C
1	Coordinates	Latitude	Longitude
2	3.321151, 101.575798	3.321151	101.575798
Data

Cell Formulas
Range	Formula
B2	=LEFT(A2,SEARCH(",",A2)-1)*1
C2	=MID(A2,SEARCH(",",A2)+1,100)*1