Removal of text from a cell containing both text and numbers

P

Paul Gapes

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

Sheeloo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cells containing text and numbers 5
Changing Text To Numbers ? 1
Formula to separate text and numbers 6
Excel Sum numbers in cells that also contain text 34
Excel Add ^ to a row of cells containing letters 3
Removing text from a cell with text and numbers 2
linking a cell containing text to another cell containing text / data 5
Splitting text and numbers from a cell 6

Top