Forum Discussion
Function similar to CONCATENATE with mixed number/text?
Using Excel 2016 on Windows 7. 3 columns: A1: Percent (e.g., 25%) B1: Percent (e.g., 50%) C1: Text that is a manually entered concatenation of A & B (e.g., 25%-50%) Can I create a formula that w...
Hi,
You can use the TEXT function which allows you to define the format within the formula.
=TEXT(A1,"0%")&" - "&TEXT(B1,"0%")
Hope that helps