Merging the Contents of Multiple Cells into One Cell in Excel

I created a small dataset in Excel about dates. The column of months had to be combined to the column of years, with a slash in between. This is how I created and then combined the contents of cells. You will see several shortcuts and tricks for using Excel.
The formula to combine the cells is =B2&"/"&A2. This creates a single cell comprising the numeric month in cell B2, then a slash, and the actual value in cell A2, which is the year.

[donmekus]

You have just saved me days of work. Even our I.T specialist was amazed that i could finish the task within seconds as it would have taken a week to finish. Thank you so much!!!!

[awmoo]

This is great! I can now merge multiple cells into one and you have saved me hours of extra work. Thank you. 😊

[playstoredaniel]

After a long search found this formula which was simple . Thank you Brother.

[ashutoshparidaap]

Thank you..but i want to ask is there any way to arrange data one below another insted side by side. I have large no of datas.

[krishnamohan]

Hello guys, I would like to bring many individual numbers from one excel sheet to single cell of another excel sheet with a negative sign in front of them ( they are basically payments ). Can anyone suggest me best short cut to do that instead I type individual numbers which is time consuming and to eliminate error while doing so. Thanks

[abdulsami]

may peace be with you doctor. you are my real teacher in statistics. i have totally relied on you in statistics.
just on thing dr. i am not able to find the video on central limit theorem. i want an explanation of this theorem from your side. can you tell me where is this video?

[playstoredaniel]

like wise i need to take the year separatly from the DD/MM/YYYY.Can you guide me.

[samatarahmed]

Is the randomised cells supposed to prevent excel from making calculations