Excel - Summarize the content of multiple columns

Latest update on October 25, 2011 at 09:26 AM by aakai1056 .

Issue
Solution

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.

Summarize text data in excel
How to summarize text data in excel - Best answers
Vba code to search data in excel - How-To - Excel
How to export data from excel to excel - How-To - Excel
How to transfer data in excel from one sheet to another - How-To - Excel
How to update data in excel using vba - How-To - Programming
How to auto update data in excel from another worksheet ✓ - Forum - Excel

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).

Excel - How to display formulas in spreadsheet?

Excel - Set first letter in uppercase

Issue

Solution

Subscribe To Our Newsletter!