I have a formula that rounds off a number from another cell. I want to add text from a different cell and have parenthesis put around that text.
For Example:
The number in one cell A1 is 45.332 and the text in cell B1 is C-5
In cell C1 is the result of the round from cell A1 which is 45.
I want to add the text from cell B1 and put quotes around it so the result in C1 is 45 (C-5)
This is the formula I have right now =ROUND(A1) & " "&B1 which results in 45 C-5 but I want the parenthesis to clarify the separation better.