removal of a value

hi guys
i have a refence linked to the internet which returns a players value
ie
£1.5m
but i dont want the
Â

how can i get rid of this?
thanks in advance

Hi,
Select the range with the offending character and hit Ctrl&H.
Enter the character to find and enter "" to replace then replace all.
You may have to copy the character 1st and paste it with Ctrl & v into the find box.

if your value of £1.5m is in cell a1 you can enter =code(a1) into a cell. This will give you the char number - you can then enter =SUBSTITUTE(A1,CHAR(Enter char number here),"")
then you can copy and paste special > values.

If your string is always in Col "A" then just copy to this worksheet and run "macro1"