Usually in the excel if we use the formula we need to drag and use other cells too.

But in the concatenate not like that, so that i am just drag all the values but put ENTER manually in each cell to update the corresponding values.

[quote=ganesang;135767]Usually in the excel if we use the formula we need to drag and use other cells too.

You're right Ganesang, the concatenate function/formula should return values based on the cell references, but our Moderator is asking you to check if your calculations is set to automatic. Go to the formulas tab, open calculation options, check the "automatic" option.

Thank you very much!!!

got it