Using concatenate in MS Excel

Step by Step:Using concatenate in MS Excel

How to Use Concatenate in excel 2003, 2007 & 2010 for combining of values in a cell or column from multiple, several or more than one cells. How to add up data of different cells in a single cell with Concat or concatenate function of MS excel? Excel has Concatenate Function that combines or adds up or brings together numeric and alphabetic values in any cell based on the concatenate specified values or cells. This formula is especially useful when you wish to present all the available information into one cell only. Data can be presented in a variety of ways.

Step 1:

(a) Sort your data
(b) Formulate your tables: these may be on the same table or on a different worksheet or even different workbooks.
(c) For the sake of example we have created two Tables in c and e:
(d) Table from where data is to be retrieved:

MS Excel Concatenate

(e) Table where data is to be fetched/desired.
MS Excel 2007 Concatenate

MS Excel 2007 Concatenate

Step 2:

Ensure spellings for search values are the same in both the tables.

Step 3:

Make sure there is no extra space.

Step 4:

MS Excel 2003 2007 Concatenate

MS Excel 2003 2007 Concatenate

Final Formula:

MS Excel 2010 Concatenate