Follow

Combining Excel Columns for Contact Importing

LionDesk can only import .CSV files with 26 columns or less (columns listed A - Z). Sometimes an address will take up multiple columns and make your spreadsheet too large to import into LionDesk. Here's how to combine columns in excel and not lose any data in the process.

 

To merge columns of data without spaces between the data, input "=A1&B1&C1" to the adjacent cell

To merge columns of data with spaces between the data, input "=A1&" "&B1&" "&C1&" to the adjacent cell

For example, in cell E1, enter “=A1&B1&C1” or “=A1&" "&B1&" "&C1”.

Press Enter and select cell E1, then drag the fill handle over the range of cells that you want to apply this formula. 

The columns of data are now merged into one!

Reminder, you can merge even more cells if you continue with the formula, as in "=A1&B1&C1&D1&E1..."

Was this article helpful?
4 out of 4 found this helpful
Have more questions? Submit a request

Comments