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.amazonaws.com/files/2023-10-27/c86686d2-1c5b-496b-b105-a8f621f6e1e5/stack_animation.webp?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIA2JDELI43YPETRQSC%2F20250228%2Fus-west-1%2Fs3%2Faws4_request&X-Amz-Date=20250228T015132Z&X-Amz-Expires=36000&X-Amz-SignedHeaders=host&X-Amz-Signature=a6775de6ea337419f1ff88cc2355cbfe11e9a1cee21855dc304d12f3bc71a0f1)
5
To apply this formula to cells below, click and drag the small square in the bottom right corner.
