How to combine columns?

  1. Home
  2. Knowledge Base
  3. Computer Basics
  4. How to combine columns?
  1. Home
  2. Knowledge Base
  3. Microsoft Excel
  4. How to combine columns?
    1. Click the cell where you want to put the combined text. Type “= (“.
    2. Click the cell that contains the first text you want to combine (like a first name).
    3. Type a space enclosed in quotation marks (“ “), and then click the next cell with the text that you want to combine (like a last name).
    4. Type ) and then press enter.
    5. To combine the text in more than two cells, continue selecting cells, and typing &” “& after each selected cell. If you don’t want to add a space between the combined text, type & instead of &” “&. To add a comma, type &”, “&.

Related Articles