Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Removing Dates


HI All,

Hopefully a quick one. I have a serious of info in a cell in this
format

11/08/2006 12:00:00
10/08/2006 12:15:00

I need to keep the time but remove all the dates from the cell. I am
using the replace function however the dates can only be run 1 day at a
time and I have over a years worth to remove,

Is there a generic format ie **/**/**** That will when put in the
replace bar will remove all dates no matter when they are?

Thanks in advance
Brento


--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=570702

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dates and Intervals Dave_Lee Excel Worksheet Functions 8 May 26th 06 01:34 PM
Removing 2 extra spaces in front of dates in imported excel doc Hannah Excel Discussion (Misc queries) 4 April 12th 06 07:37 PM
Removing Weekend dates from Day Calculations Heyna Excel Discussion (Misc queries) 2 March 3rd 06 12:41 AM
need to convert list of dates to count no. of dates by week neowok Excel Worksheet Functions 13 January 30th 06 03:54 PM
Calculating number of days between two dates that fall between two other dates [email protected] Excel Discussion (Misc queries) 5 October 26th 05 06:18 PM


All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"