/ excel help probably trivial...

This topic has been archived, and won't accept reply postings.
andic - on 28 Nov 2012
Have a column with numbers and units which I would like to plot against another set, how do I ger excel to ignore the units part part?
mkean - on 28 Nov 2012
In reply to andic:
Easiest way is to separate them using data - text to columns. I don't like having mixed columns so this would be my preference.
davidbeynon - on 28 Nov 2012
In reply to andic:

Depends on how the units are set. If it's done with formatting then they are just numbers anyway and the units are just part of the cell format so you can just use them.

If the units are actually in the cells as text then you should be able to get rid of them by selecting the cells and using "find and replace". e.g. replace "mm" with nothing.
andic - on 28 Nov 2012
Thank you chaps, know i know how to do it properly,.....

What I actually did is copy and paste the columns into igor pro and the units/text were not carried over hoorah

This topic has been archived, and won't accept reply postings.