Forum Discussion

LionChaser's avatar
LionChaser
Copper Contributor
Feb 28, 2019

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 will automatically populate column C, without having to convert columns A&B to text? I can do that but that seems like a klugy solution. Concatenate results in ".25-.25" and I haven't yet found any of the more advanced format options to get me what I want.

Resources