1. Help Center
  2. Tips And Tricks

How can I combine Excel report tokens in a single cell?

IQC Professional ( InspectionXpert) only allows one report token per column. Here's how you can combine the output from multiple tokens in a single report column.

In this example, the values from two columns will be combined into one column using the Excel "Concatenate" formula:

1) Insert the tokens that you want to combine in columns outside of your template's data fields :

concatenate 1

2) In the column where you want the combined data to appear, add the Excel "Concatenate" formula along with the cell numbers that contain the tokens:

Concatenate 2

3) In this case because the contents of Column J and Column K are being combined in Column D, the formula used in column D is =CONCAT(J7," ",K7) You can insert  a blank space or any other character such as a "/" in between the combined values by adding it to the formula.

Be sure to extend the formula so that it appears in each cell of the column down to the last row ( Footer Row)

Download this example template to see how this works:

Sample Concatenate Template

See this article on how to use the Ideagen Quality Control professional ( InspectionXpert) template editor:

Create a Custom Excel Report