TIP of the Day: Concatenate cells. Data Wizard>Custom Transformation>Custom

With the concatenate function within the Data Wizard>Custom Transformation you can concatenate specific strings, concatenate a range of cells (e.g., A2:A5), or concatenate columns where the entries in each row will be concatenated when the column names are mapped. However, if you wish to perform the operation on single cells “concatenate(A1,”&“, B34)” one needs to type it as a range “concatenate(A1:A1,”&“, B34:B34)”

An example is included.

Ana