View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default 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.