Copy only part of a cell (2003 SP3)

[steveh]

Morning all

I am gathering information from the web using a web queery, on the site the information looks like this 38^oC but when it downloads it shows as 38°C, can I copy this to another cell and omit the  without using any code? I have formatted the cell following Hans' suggesting on another topic to 0.00^o.

[sdckapr]

Not with copy but a formula. This will remove the "Â" (presuming the "38°C" is in cell A1, change as desired):
=SUBSTITUTE(A1,"Â","")

But if you are using a custom format with the °C included in the formatting, I would presume that you want the number (which can then be used in calculations) so you want to remove the "°C" as well:
=SUBSTITUTE(A1,"°C","")

Steve

[steveh]

Hi Steve

Thanks for that off to give it a try now