Stripping units from data

[nevica]

Hello,

I have a very large Excel file 6 x 1000 columns approx. Each data point has 'deg C' added at the end therefore I cannot plot it.

How do I strip the 'deg C' from each data point without doing it manually as it will take forever?

Thanks,

Nevica

[benishiryo]

hi Nevica. press CTRL + H to Find & Replace
Find What:
deg C
Replace with:

do a replace with nothing

[nevica]

Thanks, I'll see if it works.