GAS – Sheets – Address Labels

Doesn’t seem to matter which word processor you use, the label sheets never line up properly. No difference in Google Apps for this. But life can be made easier by pulling address data down from a list of rows and columns, and placing one full address in a cell, ready to go.

Let us assume you have a sheet with address data as follows:


Create another tab and enter the following in the first cell:

Your cell should end up with:


The “char(10)” puts in a soft return in side the cell. The if statements check for empty cells and ignore them if so, to prevent blank lines.

You can now repeat this formula as you wish and format your sheet to represent your preferred label format, or copy it out to a Google Doc, whatever

Leave a Reply

Your email address will not be published. Required fields are marked *