View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Gapes Paul Gapes is offline
external usenet poster
 
Posts: 1
Default 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.