Excel - Summarize the content of multiple columns

September 2017




Issue


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.

Solution

  • 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

Published by aakai1056. Latest update on October 25, 2011 at 09:26 AM by aakai1056.
This document, titled "Excel - Summarize the content of multiple columns," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).