How to change xxx d to xxx

[Guloluseus]

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.

[Pecoflyer]

The fastest way after selecting the concerned cells is Ctrl+H
Find what space)d
Replace with: (leave blank)
Click "Replace All "- Done

[Guloluseus]

Thanks Peco- wonderfully simple and effective, will teach me to overthink things

Much appreciated.