Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2014, 12:17 AM
Guloluseus Guloluseus is offline How to change xxx d to xxx Windows 7 64bit How to change xxx d to xxx Office 2010 32bit
Competent Performer
How to change xxx d to xxx
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default How to change xxx d to xxx


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.
Reply With Quote
  #2  
Old 04-03-2014, 12:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to change xxx d to xxx Windows 7 64bit How to change xxx d to xxx Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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
Reply With Quote
  #3  
Old 04-03-2014, 01:27 AM
Guloluseus Guloluseus is offline How to change xxx d to xxx Windows 7 64bit How to change xxx d to xxx Office 2010 32bit
Competent Performer
How to change xxx d to xxx
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

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

Much appreciated.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change xxx d to xxx how to change ubns Word 1 08-14-2012 03:26 AM
if letter change font also change gsrikanth Excel 1 05-15-2012 03:03 AM
How to change xxx d to xxx How to change save location and file to print name change? albertc Excel Programming 1 05-13-2012 07:05 PM
How to change xxx d to xxx change the view to final, my change bars disappear. I need them visible 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft