Dummy Essentials
A complete source of effective solutions to all your computer problems in simplified manner.

Concatenate Function In MS Excel 2007

In case you wish to combine all the characters in different columns, MS excel 2007 comes with an inbuilt function of concatenating. Let us show you how. Consider the example below. Now let us show you how to do that. Just type “=concatenate” open a bracket and select the first cell you need to combine and then put a comma and in order to insert a space between words we need to put a space between apostrophe (“ “). Again put a comma and do the same for the remaining cells as shown below. As you see above we have put up the concatenate function for all the cell to be combined. Now as soon as you press enter, all the cells will be combined. Now just copy paste the same formula below and you are done combining the cells.
0 comments:

Post a Comment

Search Dummy Essentials Here:






Visitor's Review

We would appreciate you taking out a little more of your time to rate our blog. It would help us to improve and encourage us to share whatever we get to learn in the process. Thanks!
Bookmark and Share

 Subscribe To Dummy Essentials

Enter Your Email Address & Click On Go:

  
Delivered by FeedBurner

Translate Dummy Essentials

Google-Translate-Chinese (Simplified) BETA Google-Translate-English to French Google-Translate-English to German Google-Translate-English to Italian Google-Translate-English to Japanese BETA Google-Translate-English to Korean BETA Google-Translate-English to Russian BETA Google-Translate-English to Spanish
Powered by Google

Dummy Essentials Visits