How to concatenate columns

Try converting the column with the numeric values to text using the TEXT function within the CONCATENATE function like this (it assumes data is in columns A, B, C):

=CONCATENATE(A2, B2, TEXT(C2,"00000"))

Using the text function, you must specifiy the format of the numeric to convert to text. In this example, the numeric value in column C is filled with leading zeros to make it 5-digits in length.

Hope this helps,
theDude

Hi there,

what i suggest is u make the third column as Format--->Cells--->Text
then use the concatenate Function then it works....

Originally Posted by ajkrishna001

Hi all,

My problem is to concatenate three columns as it is.

Suppose i have data as following

fjdkfldklf ca 00123
jfhdkfdjd mo 01234
fjkdlfldjk pa 12345


when i am concatenating above three columns i am not getting starting zeros of the third column, but i need as it is.


can anyone help about this.