How to replace a constant from a cell containing date and time

[BACITH]

In the below example the number in the bracket is the no of days elapse
from the date given in the cell till today. this is a software generate
report which shows the aging. i want to take only the no of days. i wan
to replace date and time. please help me to do so. Below it shows th
date and time the data was entered to the software and the no of day
elapsed.

2012-05-21 08:11:42( 135)


Thankyo

 

[Claus Busch]

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