Merge two answer into one cell

[Jagat Pavasia]

hi......Dear....

My A1 have percentage value like 23.55%, and B1 have same percentage like 63.25%.

I want answer 23.55% (63.25%) into C1.

so which formula is used in C1

 

[Fluff]

How about

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

 

[Jagat Pavasia]

How about

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

thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Peter_SSs]

thank you so much

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

 

[Scott Huish]

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