copy cell contents but not special character

steveh · Post by **steveh** » 13 Oct 2010, 14:21

Hi all

I have a cell which returns a temperature, for example 32^oC but I need to copy it to another cell to do a calculation which will not do it with the special character. at the moment I have =B13 but can I do something to say =B13 but don't copy the ^oC. I have tried to do it via the cell formatting but that does not stop it either.

Editted 15:18 to correct type

sdckapr · Post by **sdckapr** » 13 Oct 2010, 14:27

If in B13:

=VALUE(SUBSTITUTE(B13,"Â°C",""))

Steve

sdckapr · Post by **sdckapr** » 13 Oct 2010, 14:29

An alternate method is NOT to put 32Â°C into the cell, but just 32. You could add a custom format this cell to be:
0Â°C

and it would remain a number, but display the Â°C after the rounded value...

Steve

steveh · Post by **steveh** » 14 Oct 2010, 07:46

sdckapr wrote:If in B13:

=VALUE(SUBSTITUTE(B13,"Â°C",""))

Steve

Thanks for both suggestions Steve, both work fine

Eileen's Lounge

copy cell contents but not special character

copy cell contents but not special character

Re: copy cell contents but not special character

Re: copy cell contents but not special character

Re: copy cell contents but not special character