convert field with text to number

J

Jim Madsen

Is there an Excel function I can use in a spreadsheet cell formula to
convert numbers surrounded by text to a number, for further manipulation.

Specifically I want FUNCTION(E 0.384) = 0.384

The cells I want this to work on will all have "E " followed by a number.

Jim
 

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

Multiplying one known number with fluctuating numbers in cells 5
convert a number to letter 2
PLEASE HELP!!! I cant convert a cell to text for some reason. 1
convert text to values 7
convert a number to month 6
Converting Text to Number by formula (Opposite to Text("000",A1) ) 3
Convert text into formula. 7
Excel Convert text to Number 9

Top