1
To begin, open your workbook in Excel.
2
Click in the cell where you want to combine two cells with a space.
3
Type "=Concatenate." This will bring up a list of functions. Click on "CONCATENATE."
4
Select the first cell you want to combine.\
Type ", " "," (comma, space, quotation marks, space, quotation marks, comma.)\
Select the second cell you want to combine.\
Type ") [[Enter]]"
![Select the first cell you want to combine.\
Type ", " "," (comma, space, quotation marks, space, quotation marks, comma.)\
Select the second cell you want to combine.\
Type ") [[Enter]]"](https://colony-recorder.s3-accelerate.amazonaws.com/files/2023-10-27/c86686d2-1c5b-496b-b105-a8f621f6e1e5/stack_animation.webp?AWSAccessKeyId=AKIA2JDELI43YPETRQSC&Signature=9ki7y5ka5cKN7KSPpv%2BBlwuW0gg%3D&Expires=1731637897)
5
To apply this formula to cells below, click and drag the small square in the bottom right corner.
