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

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

Support & Legal
Support/Knowledgebase Status Privacy Policy Terms of use Contact Us