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 you

Try Badger with your Team

See how your sales team can sell more

Badger Maps

1 Sansome Street, Suite 3500, PMB #42821

San Francisco, CA 94104, USA

415-592-5909
Support & Legal
Support Status Privacy Policy HIPAA Compliance Terms of Use Contact Us