Combining 2 cell contents and add a space in between (concatonate)

Dan Harris

I have combined 2 cells content using + , how do I add space back into the 2 words pulled from the separate cells see below what currently looks like, should be a space between the words!

Thanks

Leibel S

place the below to your formula between the cell references

+ " " +

Leibel S

place the below to your formula between the cell references

+ " " +

Heather Duff

Hi Dan! You'll want to put + " " in the middle. So, for example:

=[Column1]@row + " " + [Column2]@row

This adds text (the space) in between the two cells.

Best,

Heather

Dan Harris

great thanks