How to Combine Two Columns in Excel With a Space | Scribe

    How to Combine Two Columns in Excel With a Space

    • |
    • 0 step |
    • 35 seconds
      To begin, open your workbook in Excel.
      Click in the cell where you want to combine two cells with a space.
      Type "=Concatenate." This will bring up a list of functions. Click on "CONCATENATE."
      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]]"
      To apply this formula to cells below, click and drag the small square in the bottom right corner.
      Was this Scribe helpful?
      Save this document for future reference.
      click-target-circles-background
      This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe