Concatenate

[tomas]

Hello

I would like to formula to join cells A1 and B1 into one cell C1 but to put number in second column into brackets.

I tried =A1&''("&B1&")" but did not work please help

 

[Asheesh]

Hi Tomas - Check this one...

=A1&"( "&(B1*100)&"% )"

 

[tomas]

Hi Tomas - Check this one...

=A1&"( "&(B1*100)&"% )"

thanks it worked .

PS : I have one more problem if sourcing cells have many decimal places how can I eliminate them in the final formula

 

[John Jairo V]

Hi @tomas (and @Asheesh)

Another one:
=A1&TEXT(B1," (0.00%)")

 

[Asheesh]

Tomas - solution that John has suggested will take care of the question you asked...however, you can also use functions like round, roundup , rounddown & text function

For details visit : http://chandoo.org/wp/2012/09/28/round-numbers-excel-formulas/

 

[tomas]

Tomas - solution that John has suggested will take care of the question you asked...however, you can also use functions like round, roundup , rounddown & text function

For details visit : http://chandoo.org/wp/2012/09/28/round-numbers-excel-formulas/

Actually meanwhile I got that on my own . But I would ask another one. It's not I am lazy on my own but lot of things to learn these days. I need a function to separate numbers like I mean not 1000000 but 1 000 000 because it looked bed in powerpoint

 

[Khalid NGO]

Actually meanwhile I got that on my own . But I would ask another one. It's not I am lazy on my own but lot of things to learn these days. I need a function to separate numbers like I mean not 1000000 but 1 000 000 because it looked bed in powerpoint

Hi Tomas,
If i understood correctly, you can use custom format...
Press Ctrl+1 > Number > Custom > Type:
# ### ###

But i think this would be much easier to read / understand:
#,##0

Regards,

 

[tomas]

Hi Tomas,
If i understood correctly, you can use custom format...
Press Ctrl+1 > Number > Custom > Type:
# ### ###

But i think this would be much easier to read / understand:
#,##0

Regards,

Hi Tomas,
If i understood correctly, you can use custom format...
Press Ctrl+1 > Number > Custom > Type:
# ### ###

But i think this would be much easier to read / understand:
#,##0

Regards,

thanks Khalid