Join Text

Location on ribbon: Tab DVD Addin → Group Cells and Rows

Command ID: btnGetSheetPrint

What it does

The command takes the value of every non-empty cell in the selection, joins them into a single string using a configurable delimiter, and writes the result into a cell you pick. The output is plain text, not a formula, so it never returns #VALUE! even when the selection mixes text and numbers.

Use it to build the sheet-code list that Batch print expects (YCNTCV+BBNTCV+KT_DD), to flatten a material list into one line, or to combine member codes into a description string.

How to use

1. Select the cells whose values you want to join (empty cells are skipped automatically).
2. Click DVD Addin → Cells and Rows → Join Text.
3. The prompt "Select cell to paste" appears — click the destination cell and press OK.
4. The joined string is written there and the status bar reports "Joined 5 cells into H2".
5. To change the separator, go to Preferences → Cells and Rows → Delimiter for Join Text: Space (default), Comma, Semicolon, Newline or Custom (your own text, e.g. +).

Example

A batch-print configuration sheet needs one cell listing the form codes to print for each section. In Preferences set the delimiter to Custom = +, then select B2:B4 holding YCNTCV, BBNTCV, KT_DD, click Join Text and pick E2 as the destination.

Before (B2:B4)	After (E2)
YCNTCV	YCNTCV+BBNTCV+KT_DD
BBNTCV
KT_DD

Notes

• The result is static text and does not update when the source cells change — rerun the command after edits.
• The raw cell value is used, not the formatted display text, so specially formatted dates and numbers appear in their underlying form.
• Leading and trailing spaces of each cell are trimmed before joining.
• With no selection, or when no selected cell holds data, the status bar says so and nothing is written.
• The destination cell is overwritten without confirmation and Ctrl+Z cannot undo it.

Related

• Join Merged — joins merged-cell addresses instead of values, using the same delimiter.
• Batch print — consumes the CODE1+CODE2+CODE3 string you just built.
• Preferences — where the Join Text delimiter is configured.