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  &”, “&.

See Badger in Action

Check out our full walkthroughs

Request a Demo

See what Badger can do for your team

Badger Maps

539 Broadway

San Francisco, CA 94133, USA

415-592-5909
Support & Legal
Support/Knowledgebase Status Privacy Policy Terms of use Contact Us