How can I concatenate a percentage in MS Excel?

Question

I have just learned about concatenation in MS Excel. For example, I have separate columns for 5, 10 and 50% and I want to concatenate in a new column so that I get 50% (5/10). I have the formula ok but instead of the percentage I get a decimal (0.5), or 1 if it's 100%. e.g. 0.5 (5/10)

How can I change it so that the percentage appears and I get what I want, i.e. 50% (5/10)

Thanks for any advice.

Answer 1

You could cheat and do it this way:



=CONCATENATE(A1*100,"% (",B1,")")



where A1 = 50% and B1 = 5/10



or you can use the Text() function to format the percentage:



=CONCATENATE(TEXT(A1,"0%")," (",B1,")")

Answer 2

Concatenation In Excel

Answer 3

The other way is using the TEXT() function.

A1 = 5

B1 = 10

C1 = '=TEXT(A1/B1, "000.000%")'



Keep in mind that the single quotes above shouldn't be copied into the cell.

The "TEXT()" function is nice this way, because you can format the result differently. If you wanted the percent sign at the beginning, you'd merely have to enter '=TEXT(A1/B1, "% 000.000")' in cell C1.

Answer 4

once you're working in a sort: Create a container and set its administration source to [call of proportion container]&[call of fraction container]. (you ought to open the properties window, in layout mode, with the intention to work out the administration source. you ought to additionally set the record source of the type to the table or question the place the counsel fields are). the different help, please stay in touch. Makiavel

Answer 5

from the format toolbar press % symble

or

right click the cell then choose cell format and under the unmber tab choose percentage



anyway it works perfect!

Enjoy it!