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

Watch a Demo Video

See Badger Maps in Action

Get a Live Demo

Chat with our sales team & get a custom demo

Try Badger with your Team

See how your sales team can sell more

Support & Legal
Support Status Privacy Policy HIPAA Compliance Terms of Use Data Processing Addendum Contact Us Manage Cookies