Ok, so the problem is pretty much in the title.

I was using an ancient instrument to record some data for a chemistry project I am doing at my university. When copying the output to excel, all of the readings for temperature are in - number C - form (to denote degrees celcius). eg. 3.016 C

There are about 3000 readings and to plot the data I don't want to have to go through each and backspace the C. Is there any way around this, to remove the C from all at once??