Forum Discussion
Formula for replacing values
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...
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.
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.
Thanks, Greg! Would it still work after I refreshed the data?