aderowbotham/spreadsheet-concatenate.md

Last active November 2, 2015 15:33

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/aderowbotham/88d02339979ff8639a9e.js"></script>
Save aderowbotham/88d02339979ff8639a9e to your computer and use it in GitHub Desktop.

Download ZIP

Spreadsheet concatenation formulae

Raw

spreadsheet-concatenate.md

Spreadsheet concatenation formulae

These are tested in Open Office. May need modifying for Excel.

Combine multiple address fields into one

Contatenate cells B5 - F5, inserting a comma and line break, only if the cell is not blank

=IF(TRIM(LEN(B5));B5&","&CHAR(10);"")&IF(TRIM(LEN(C5));C5&","&CHAR(10);"")&IF(TRIM(LEN(D5));D5&","&CHAR(10);"")&IF(TRIM(LEN(E5));E5&","&CHAR(10);"")&IF(TRIM(LEN(F5));F5;"")