ou can,
As long as ever you can.” - John Wesley
---------
From: Ashish Bhalara
>To: "excel-macros@googlegroups com"
>Sent: Friday, May 2, 2014 2:51 AM
>Subject: $$Excel-Macros$$ Need help in Mid function
>
>
>
>Dear experts,
>
&g
Hi
You can use SUBST function in this case.
Cheers!!
On Fri, May 2, 2014 at 12:21 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> I need the middle value between two particular word as per below sentence.
>
> Sentence:Being amt. of claim *incentive for CE of Apr-14* claim
> receivable from TDL.
Dear experts,
I need the middle value between two particular word as per below sentence.
Sentence:Being amt. of claim *incentive for CE of Apr-14* claim receivable
from TDL.
Output of function should be "incentive for CE of Apr-14"
The two particular word is "amt. of" & "claim receivable"
Tha
