Text Expression

The Text Expression column can be used to combine columns and variables into a single text expression. In other words, you can concatenate text and numbers into one text column.

Here is how it works:

  • Create a Text Expression column using the Other drop-down menu
  • Use the small ‘+’ button to see a menu of available columns/variables that you can include
  • Combine with text that you type in the field

In the following example, a Text column (‘Group’) and a Number column (‘Run’) are combined using a Text Expression column (‘Label’).

Related Articles