MS Excel Combining Data From Different Columns
Working with MS Excel data like text sometimes calls for combining a set of column data to formulate a new column. An example could be column A would be combined with column B with result put on column C.
column A column B column C
JAN 2008 JAN2008
FEB 2008 FEB2008
Something like this could sometimes be frustrating. Two ways of combining two or multiple columns of data in MS Excel:
1. Using the CONCATENATE function
2. Using the & operator
Both will give the same result, but the way each is used to accomplish the same task is a little bit different.
Using the CONCATENAT function:
1. Go to column C
2. In the cell type the following
=CONCATENATE(column A, column B)
The function with the particular data would look like this =CONCATENATE(‘JAN’,’2008′)
Using the & operator:
1. Go to column C
2. In the cell type the following
= column A & column B
The function with the particular data would look like this = ‘JAN’ & ’2008′
This is useful when generating tags which is derived from combined column of data. This is a basic stuff when using MS Excel. If an in depth knowledge is required, attending an excel training course would be needed. Hoping that the above example would be of help to you.
Posted on
Wednesday, January 30th, 2008 at 8:46 pm under 