Excel - Summarize the content of multiple columns

October 2016


I want to make a column that summarizes 3 other columns
  • My 3 columns are composed of IF formula that gives a number based on a product name in N-1column.


  • If your data is in text format:
    • =A1&B12&C12 
  • If your data are numeric values??:
    • =CTXT(A1;0)&CTXT(B1;0)&CTXT(C1;0) 
  • The FIXED function converts numeric values ??to a string, the 0 indicates the number of decimal places.
  • Even simpler: use the =CONCATENER(A1;B1;C1) function

Thanks to pepe for this tip.

Related :

This document entitled « Excel - Summarize the content of multiple columns » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.