Here is one way to display percentages and numbers together in one column that are currently stored in separate columns on a worksheet, its a neat little trick I used recently when I had to display both a number value as well as it’s corresponding percentage value in the same text box on a diagram in Excel. All I needed to do was join or ‘concatenate’ the two values into one column then reference the text box to that column cell. The result was a nice, neat annotated diagram.

If you want to learn the basics about Concatenate?. You can do so right HERE!

If you want to jump right in and look at joining together a number and a percentage then the syntax of the formula looks something like this:-

**=CONCATENATE(A2,” “,TEXT(B2,”0%”))**

See it in action in my example below

Give this one a go- let me know how you get on.

Sisca says

Dear,

Thank You for your inform and i have been succed used this formula.

but in my case, for % is 0.11%… if i combine it, percentage just show 0%

please help me to solve this.

Thank You

Dan says

Change the “0%” to “0.00%” it will keep 2 decimal places…

kushal shah says

how to use minus(-) in concatenate formula

Skawen says

Thank You this was really helpful !

Barbara says

Glad you found it helpful

Barbara

Patrick says

Thanks! This is an awesome workaround that saves me at least 45m a month.

Barbara says

Happy it helps Patrick

Regards

Barbara

Dave says

Why not use & ? It’s much simpler than =concatenate