Concatenate Formula not working

Hello friends,

I am facing an issue in my Excel sheet,I have been using the concatenate function from a long back but now it just stopped working and these are numerical columns. I normally go to insert option - - > Function - - >Concatenate.

Can anyone fix this issue fro me.I would be very great full to him.

Sure i will help you out with this try to use this formula =CONCATENATE(B2,C2,D2,E2) and make sure your calculation tab is in automatic mode.


Intel Core 2 Duo 2.8 Ghz
G31 Asrock Motherboard with Intel chipset
2gb RAM
256 Nvidia Graphic Card
200gb HDD

I was also facing similar type of issue i try to disable the TFE or AEE option.

For that you need to follow the below steps:-

1. Click on Tools Menu, then click on Preferences and click the Transition tab.
2. Now under Sheet Options, clear the Transition Formula Evaluation check.