ERROR: Array result was not expanded because it would overwrite data

[Vijender]

Hi,

I have to measure distance between coordinates for which:

1) I have built an app to get "LatLong" points.

2) For getting the distance between two points, I have written formula on spreadsheet. But for getting the distance using spreadsheet formula, I have to split Latitude and Longitude into different cells.

For splitting the "LatLong" to Latitude(in one cell) and Longitude(in other cell) I have used the formula in spreadsheet as "=SPLIT(U2,",") 

Can someone help me regarding this?

About the screenshot:

Column "Location"=> Record Latlong point through app.

Column "Latitude and Longitude" => split the Latitude and longitude into two different columns using spreadsheet formula. But, sometimes it gives the error(Array result was not expanded because it would overwrite data in W11.) as mentioned in screenshot and fail to split LatLong.