How to convert a sentence into a number

Posted by Anders on September 13, 2000 3:46 AM

I have a problem converting a phrase into a number.

In a column I have got several durations for activities denominated with say, "5 days". To process these data I would like to skip the "days" and simple use the number of days staded. Is there anyone who knows a simple way to do this? Any suggestions will be appreciated a lot! Brgds Anders

Posted by Celia on September 13, 0100 5:39 AM

Anders
If the number and the text is always separated by one space :-
=LEFT(A1,FIND(" ",A1)-1)*1
Celia

Posted by Anders on September 13, 0100 7:08 AM

Celia,

it worked perfectly (as allways), thanks alot!

Anders.