How to remove °C from cell

[joelcombo]

so ive tried using the formula
To remove °C from 10 °C for example

=LEFT(E10,LEN(E10)-SUM(LEN(E10)-LEN(SUBSTITUTE(E10,{"A","B","C","D","E","F","G","H"},""))))

In an attempt to remove it but i get

10.0 °

Theres still a degree remaining, how do i completely remove this?

 

[RoryA]

Welcome to the forum.

Why don't you just use =trim(SUBSTITUTE(E10,"°C",""))

 

[Rick Rothstein]

Welcome to the forum.

Why don't you just use =trim(SUBSTITUTE(E10,"°C",""))

Or even this...

=0+LEFT(E10,LEN(E10)-2)

 

[Mark F]

Just a thought, could the cell Number Format have the degree symbol in it? Format Cells, Number Format, Custom
EDIT...just re-read the post, and realised this is not the issue

Mark