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.

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

Much appreciated.