Hi Rajan,
Thanks for the formula, it actually works great...only if i could be able
to interpret the rational used in the formula. Thanks very much.
The last column is not material as some cells had only one figure to total
trans amt without any figures for Tot Dep Trans Amt and Tot W/D Trans Amt
w
For Two Columns Use this Formula .
=MID($A2,FIND("*",SUBSTITUTE($A2,"KES","*",COLUMNS($B$1:B1)),1)+3,FIND("Tot"
,$A2,FIND("*",SUBSTITUTE($A2,"KES","*",COLUMNS($B$1:B1)),1)+2)-FIND("*",SUBS
TITUTE($A2,"KES","*",COLUMNS($B$1:B1)),1)-3)
Can you please tell what amount need to come in las
Hi Singh,
Thank you very very much. U have saved me a lot of manual work.
Regards,
Boreh
On 7 September 2012 14:53, Karan Singh wrote:
> Hi Robinson,
>
> Pl. find attachment. I'v solved both column queries but what is "Tot Trans
> Amt"? I was not able to understand that. I'v done this with lots
You can also try this for 2nd column :
=IFERROR(LEFT(MID(A2,FIND("Tot W/D Trans Amt = KES ",A2,1)+LEN("Tot W/D
Trans Amt = KES "),FIND("Tot W/D Trans Ct ",A2,1)),FIND("Tot W/D Trans
Ct",MID(A2,FIND("Tot W/D Trans Amt = KES ",A2,1)+LEN("Tot W/D Trans Amt =
KES "),FIND("Tot W/D Trans Ct ",A2,1)),1)-
Hi Singh,
Thanks, its works. What about the other two columns?
Regards,
Boreh
On 7 September 2012 13:40, Karan Singh wrote:
> Hi Robinson,
>
> Pls use below formula and drag it down or Ctrl+D for Tot Dep Trans Amt :
>
> =SUBSTITUTE(MID(A2,FIND("KES
> ",A2),LEN(LEFT(A2,FIND(CHAR(10),A2)-2))-FIND
Hi Robinson,
Pls use below formula and drag it down or Ctrl+D for Tot Dep Trans Amt :
=SUBSTITUTE(MID(A2,FIND("KES
",A2),LEN(LEFT(A2,FIND(CHAR(10),A2)-2))-FIND("= ",A2)),"KES ","")
Rgds
Karan Singh
On Fri, Sep 7, 2012 at 3:34 PM, Robinson Boreh wrote:
> Dear Members,
> I need assistance on
