Hi there,
I've extracted some lats and longs from Google and want to split them into separate cells and remove the degrees character and direction. Any idea how to do this in one go? e.g. I'd like to convert a whole load of lat/longs in one text string in a cell from this format to this:[TABLE="width: 267"]
<colgroup><col></colgroup><tbody>[TR]
[TD]e.g lat long cardiff[/TD]
[/TR]
[TR]
[TD]From:[/TD]
[/TR]
[TR]
[TD]51.4780° N, 3.1771° W[/TD]
[/TR]
[TR]
[TD]To:[/TD]
[/TR]
[TR]
[TD]51.4780,-3.1771[/TD]
[/TR]
[TR]
[TD]e.g. [/TD]
[/TR]
[TR]
[TD]lat long cape town[/TD]
[/TR]
[TR]
[TD]From:[/TD]
[/TR]
[TR]
[TD]33.9767° S, 18.4244° E[/TD]
[/TR]
[TR]
[TD]To:[/TD]
[/TR]
[TR]
[TD]-33.9767, 18.444[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl63, width: 267"]
[/TD]
[/TR]
</tbody>[/TABLE]
Any help as always would be much appreciated,
Thanks
Loto
I've extracted some lats and longs from Google and want to split them into separate cells and remove the degrees character and direction. Any idea how to do this in one go? e.g. I'd like to convert a whole load of lat/longs in one text string in a cell from this format to this:[TABLE="width: 267"]
<colgroup><col></colgroup><tbody>[TR]
[TD]e.g lat long cardiff[/TD]
[/TR]
[TR]
[TD]From:[/TD]
[/TR]
[TR]
[TD]51.4780° N, 3.1771° W[/TD]
[/TR]
[TR]
[TD]To:[/TD]
[/TR]
[TR]
[TD]51.4780,-3.1771[/TD]
[/TR]
[TR]
[TD]e.g. [/TD]
[/TR]
[TR]
[TD]lat long cape town[/TD]
[/TR]
[TR]
[TD]From:[/TD]
[/TR]
[TR]
[TD]33.9767° S, 18.4244° E[/TD]
[/TR]
[TR]
[TD]To:[/TD]
[/TR]
[TR]
[TD]-33.9767, 18.444[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl63, width: 267"]
[/TD]
[/TR]
</tbody>[/TABLE]
Any help as always would be much appreciated,
Thanks
Loto