2 cells value to 1 cell

[Guest]

Hello from Steved

In cell B9 I have $1
In cell C9 I 775 $

Please what formulais required in Cell D9 to show $1775
Please I need also to remove the $ from C9
I've got over 300 lines to do.

Thankyou in advance.

 

[N Harkawat]

on cell d9 type
=--(b9&c9)

 

[Guest]

Hi,

i know this looks daunting, but ry this.

To show US$ 1775.

In cell D9, array enter the following (Ctrl+Shift+Enter)

1*MID(B9,MATCH(TRUE,ISNUMBER(1*MID(B9,ROW($1:$5),1)),0),COUNT(1*MID(B9,ROW($1:$15),1)))
&
1*MID(C9,MATCH(TRUE,ISNUMBER(1*MID(C9,ROW($1:$5),1)),0),COUNT(1*MID(C9,ROW($1:$15),1)))

Hope this works

Regards,

 

[Guest]

Thankyou

 

[CLR]

First Highlight column C, then Edit > Replace > $ > (nothing) > Replace
all...........this will get rid of the $ in column C

then in D1 put this formula and copy down......format column D for currency

=(B9*1000)+(C9*1)

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thankyou.

First Highlight column C, then Edit > Replace > $ > (nothing) > Replace
all...........this will get rid of the $ in column C

then in D1 put this formula and copy down......format column D for currency

=(B9*1000)+(C9*1)

Vaya con Dios,
Chuck, CABGx3