When using our Postcard mailing services, you can upload your addresses in a spreadsheet. For best results, organize your data into separate columns. If some addresses are combined in one cell, use a delimiter to split them into multiple columns.
What's a delimiter?
A delimiter is a character that separates parts of your data so a spreadsheet can split them into columns.
Examples of common delimiters:
Commas: John Doe, 123 Main St, New York
Semicolons: Jane Smith; 456 Oak Ave; Chicago
Spaces: Jay Sample 12 Bird St Kansas City
How to split cells in Microsoft Excel
Select the cells you want to split
Make sure you highlight all the rows in the column that contain the combined data.
Select Text to Columns
Go to the Data menu in the top navigation bar and select the Text to Columns.
Choose Delimited
This tells Excel that a specific character separates your data. Then select Next to move to the next step.
Choose the delimiter
Select the character used in your file, such as a comma or semicolon.
Select the destination
Confirm the cell or column where you want the new data to appear.
Select Finish
Excel will complete the split and organize your data into new columns.
How to split cells in Google Sheets
Before you start, make sure there is an empty column next to your data, since Google Sheets will overwrite the column to the right. Google Sheets often detects the separator automatically to help speed up the process.
Select the cells you want to split
Highlight the specific column containing your combined addresses.
Select Data and then Split text to columns
Find this option in the top bar. You can choose a specific separator if the automatic detection does not match your data.
How to merge data from two cells
If you need to combine data from two columns into one, you can use a simple formula. This works in both Google Sheets and Microsoft Excel.
Select the destination cell
This is the empty cell where you want the combined information to appear.
Type the equals sign (=)
Starting with this sign tells the spreadsheet to perform an action.
Select the first cell you want to merge
Select the cell containing the first part of your data, like a first name.
Type &" "&
Including the space between the quotation marks prevents your data from running together.
Select the next cell you want to merge
Select the second cell, like a last name. Your final formula should look like this: =A1&" "&B1
Press Enter
The spreadsheet will display the combined text from both cells.
