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.
|