Create a Combination Field for a Folder

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

  1. In the Navigation Pane, click the folder for which you want to create the combination field.

  2. On the View tab, in the Current View group, click View Settings.

  3. In the Advanced View Settings: <view> dialog box, click Columns.

  4. In the Show Columns dialog box, click New Column.

  5. In the Name box, type a name for the column.

  6. In the Type box, click Combination.

  7. Click Edit.

  8. To append each value for the fields that you want to use together, click Joining fields and any text fragments to each other.To show only the first field that is not blank, click Showing only the first non-empty field, ignoring subsequent ones.

  9. Click Field, point to the field set that you want, and then click the field that you want to appear.

  10. Repeat step 9 to add each field that you want to appear.

  11. Click OK twice.

  12. To position the field between the other fields in the view, click the field, and then click Move Up or Move Down.

    To remove the field from the view, click Remove.

Note Note
  • Combination fields appear with the default format of the data type used. To display a data type with a custom format, you must create a formula field and use the Format function.

  • You cannot sort, group, or filter the contents of a combination field.