Hi Asharfi,
If before date ")," are fixed
Then try
=VALUE(RIGHT(C6,LEN(C6)-LEN(LEFT(C6,FIND("),",C6)))-2))
.
Enjoy
Team XLS
On Mon, Apr 15, 2013 at 6:51 PM, wrote:
> Sent from BlackBerry® on Airtel
> --
> *From: * "Arjun S Gupta"
> *Dat
:excel-macros@googlegroups.com]
On Behalf Of asha...@gmail.com
Sent: 15 April 2013 6:52
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fw: Help Needed
Sent from BlackBerryR on Airtel
_
From: "Arjun S Gupta"
Date: Mon, 15 Apr 2013 18:35:44 +0530
To:
Subject:
Sent from BlackBerry® on Airtel
-Original Message-
From: "Arjun S Gupta"
Date: Mon, 15 Apr 2013 18:35:44
To:
Subject: Help Needed
Hi All,
Garden Fresh Restaurant Corp., L+1175 (L+975 Cash/2.00% PIK), 12/11/13
=IF(ISERROR(TRIM(MID(A45,FIND("/",A45)-2,8))),"",TRIM(MID(A45,FIN
