2 cells value to 1 cell

S

Steved

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.
 
A

Ashish Mathur

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,
 
C

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
 
S

Steved

Thankyou.

CLR said:
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
Click to expand...
 
Top