Is there a way to put spaces between the data you are trying to concatenate? I've merged 3 cells into one with a concatenate formula but there's no spaces in between the data. For example:
A1 has Half & Half
B1 has 4
C1 has 96 oz
When I concatenate it the results are Half & Half496 oz. I would like spaces between Half and 4 as well as between 4 and 96 oz.
A1 has Half & Half
B1 has 4
C1 has 96 oz
When I concatenate it the results are Half & Half496 oz. I would like spaces between Half and 4 as well as between 4 and 96 oz.