Names, addresses, and other data are often split between two or more cells in an Excel database file.
If you need to combine such data into a single cell, try using the CONCATENATE function.
CONCATENATE works not only on text, but it can also handle numbers, blank spaces, or even the cell reference to the data's location in the worksheet.
To find out more, read this short tutorial on how to Combine Cells of Data in Excel with the Concatenate function.
Related Tutorials

please teacher i have got one problem about the charts, that is when i am using my excel worksheet if my fingers touch keyboard by mistake .charts go into my worksheet so sometimes more charts go into my worksheet so how can i remove these charts.