![]() |
|
#1
|
|||
|
|||
![]() 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. |
#2
|
||||
|
||||
![]()
The fastest way after selecting the concerned cells is Ctrl+H
Find what ![]() 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 |
#3
|
|||
|
|||
![]()
Thanks Peco- wonderfully simple and effective, will teach me to overthink things
![]() Much appreciated. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ubns | Word | 1 | 08-14-2012 03:26 AM |
if letter change font also change | gsrikanth | Excel | 1 | 05-15-2012 03:03 AM |
![]() |
albertc | Excel Programming | 1 | 05-13-2012 07:05 PM |
![]() |
anna.a.julin | Word | 1 | 03-01-2012 08:05 PM |
"Change Word Options" don't change | ADKREV | Word | 0 | 11-12-2010 10:56 AM |