[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.