=TRIM(RIGHT(D3,LEN(D3)-FIND(")",D3)))
Regards
Ashish Koul
On Wed, Jul 10, 2013 at 4:20 PM, Prafull Jadhav wrote:
> Dear Amar,
>
> find the same with easy...by using mid function.
> Regards
> Prafull
>
>
> On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar wrote:
>
>>
>>
Dear Amar,
find the same with easy...by using mid function.
Regards
Prafull
On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar wrote:
>
> --
> *From:* amar takale
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, 4 September 2012 2:01 PM
> *Subject:* $$Excel-Macr
From: amar takale
To: excel-macros@googlegroups.com
Sent: Tuesday, 4 September 2012 2:01 PM
Subject: $$Excel-Macros$$ Simple formula required
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ memb
Or
=IF(ISERR(FIND(")",D3)),"",TRIM(MID(D3,FIND(")",D3)+1,255)))
<><><><><><>
*Ms.Exl.Learner*
<><><><><><>
---
On Tue, Sep 4, 2012 at 2:01 PM, amar takale wrote:
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members alrea
=TRIM(RIGHT(SUBSTITUTE(D3," ",REPT(" ",LEN(D3)),1),LEN(D3)))
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 04 September 2012 2:01
To: excel-macros@googlegroups.com
Subject: $$Ex
Hi Amresh,
Formula is ok.But other word file is fantastic.Amazing amresh
Thanks very much
On Tue, Sep 4, 2012 at 2:28 PM, Amresh Maurya wrote:
> find the attached solution - 1
>
> solution - 2 you can use this formula
>
> =TRIM(SUBSTITUTE(D4,LEFTB(D4,FIND(")",D4,1)),""))
>
> find the attached s
