Formula for replacing values

[Anonymous]

 Hi everyone,

 I'm trying to pull longitude and latitude data from a ship-tracking website and create the "map" visualization based on it:

https://www.myshiptracking.com/vessels/deepsea-yantai-mmsi-311000483-imo-9731638

And it comes in this format after some manipulation with columns:

Since the coordinates will be changing, I guess I need a formula that will be automatically converting this text into the decimal number (without the deg symbol °) each time I refresh the data. It should look like this I guess:

What would the fomula be? And do I replace the text with this formula or do I create a new column?

Thanks in advance 🙂

[Syndicate_Admin]

Were you all able to get this working?  I'm doing something similar, and I'm experiencing a weird issue where it seems like ReplaceValue can't find the ° symbol.  I've copied and pasted it exactly like it is in Power Query but it isn't finding this character.

Have you all seen anything like this?

[Greg_Deckler · Accepted solution]

In Power Query, select each column and do a Replace Values to replace your degree symbol with blank. Or, you could do a essentially a Left of length - 1 in a new column.

[Anonymous]

Thanks, Greg! Would it still work after I refreshed the data?