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.
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?
