Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to replace a constant from a cell containing date and time
In the below example the number in the bracket is the no of days elapsed from the date given in the cell till today. this is a software generated report which shows the aging. i want to take only the no of days. i want to replace date and time. please help me to do so. Below it shows the date and time the data was entered to the software and the no of days elapsed.
2012-05-21 08:11:42( 135) Thankyou |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to replace a constant from a cell containing date and time
Hi,
Am Wed, 3 Oct 2012 10:28:53 +0000 schrieb BACITH: In the below example the number in the bracket is the no of days elapsed from the date given in the cell till today. this is a software generated report which shows the aging. i want to take only the no of days. i want to replace date and time. please help me to do so. Below it shows the date and time the data was entered to the software and the no of days elapsed. 2012-05-21 08:11:42( 135) select your column = Data = Text to Columns = Fixed Width = Next = put 1 delimiter behind the opening bracket and one in front of the closing bracket = Next = first and third column = Do not import the column = Finish Or do it with formula: =--TRIM(SUBSTITUTE(MID(A1,FIND("(",A1)+1,99),")",)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text in a cell invoke constant date in another cell - how | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |