Removal of text from a cell containing both text and numbers
 

I would like to isolate the numerical data from a cell containing both text
and numbers. For example WD=210. I want to remove the equals sign and the
letters WD.
I am collecting weather data from a instrument and have a requirement to
remove the text so I can display this on a graph.

Removal of text from a cell containing both text and numbers
 

If your data are in Col A starting in A1
then type the following in B1 and copy down
=RIGHT(A1,LEN(A1)-FIND("=",A1))

"Paul Gapes" wrote:

I would like to isolate the numerical data from a cell containing both text
and numbers. For example WD=210. I want to remove the equals sign and the
letters WD.
I am collecting weather data from a instrument and have a requirement to
remove the text so I can display this on a graph.