How to combine columns?

  1. Select the cell where you want to put the combined data.
  2. Type  =  and select the first cell you want to combine.
  3. Type  &, add quotation marks  ” “  with a space enclosed, then type another  &  after the quotation marks.
  4. Select the next cell you want to combine and press enter. An example formula might be =A2&” “&B2.
  5. To combine the text in more than two cells, continue selecting cells, and typing  &" "&  after each selected cell. If you don’t want any space between the combined text, just type  &  instead of  &" "&. To add a comma, type  &”, “&.
Support & Legal
Support Status Privacy Policy HIPAA Compliance Terms of Use Data Processing Addendum Contact Us