Need formula help

[Jayanta85]

I have two separate column which contain word data and in another column % data. I need to add this two column and it need to show % within bracket. Please see the below data and give me formula how can I add this two column with adding bracket.

Thanks and wait for reply.

[#2]

@Jayanta85 

Let's say the text values are in A2 and down, and the percentages in B2 and down.

In C2:

=A2&" ("&TEXT(B2,"0.0%")&")"

Fill down.

If you have Microsoft 365 or Office 2021, you can also use a single formula:

=A2:A11&" ("&TEXT(B2:B11,"0.0%")&")"

Adjust the ranges as needed. The formula will automatically spill to the rows below.

[#3]

Thanks for your help and it really work.