MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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

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


it worked perfectly (as allways), thanks alot!