Apologies in advance for the probable easy solution.

I have a column of numbers imported from MS project representing task durations, this gives a list in the format
1 d
1.2 d
13.2 d
etc

where the number of days (integer or decimal) between 0 and 100 is followed by a space, then letter d. I need to adjust this so I just have the number (do that e.g. 1.21 d becomes 1.21). I tried using LEN, LEFT and RIGHT but my knowledge just isnt quite enough.

Thanks in advance.