* *
>
> *Can you please tell what amount need to come in last column.*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com
uot;,"*",COLUMNS($B$1:B1)),1)-3)
Can you please tell what amount need to come in last column.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Robinson Boreh
Sent: 07 September 2012
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
Dear Members,
I need assistance on how to extract figures from a string of text. I
have attached an excel sheet which contains various date in a cell. I
have Tot Dep Trans Amt, Tot W/D Trans Amt and Tot Trans Amt all in one cell
and i need to extract an amount for each amount into its own cell. I h
