Skip to main content

Joining Texts from Multiple Cells in Excel

Combining Texts in MS Excel

 

Programs like MS Excel is full of functions. There are many useful functions that we don't use or we don't know about. One of them is CONCATENATE. It means joining or linking. With this function you can join texts from multiple cells. Let's see how . . .


Suppose you're working in an Excel Worksheet where you need to combine texts from different cells. I'm gonna show you an example. Let's consider the image below - 

 

CONCATENATE Functions in Excel

What do you see? I've imputed First Name and Last Name. In Full Name column I've used the formula i.e. CONCATENATE. And in the last column I've added Mr. with the full name. 

 

So how do you use this formula? Here it is - 

=CONCATENATE(A2," ",B2)

Observe it carefully. You can add more than 02 cells with this functions. Here I've just used 02 cells. You may think what is this " " for? You may notice that there is a space between the two i.e. " & ". 

If you don't use " " then your full name will be like AbdurRahim. But two words should be separate. And for this weed need to put space. But in computer you should know space is a kind of character. That's why we need to put space between this quotation " " mark.  


Now you have the full name in column C. If you wanna put Mr. before the full name then you can do it this way - 

=CONCATENATE("Mr. ",C2)

Since we have the full name in Column C we can simply put "Mr. ",C2 within the bracket. You should notice that there is a space after Mr. so that we get the name as Mr. Abdur Rahim. 

 

There is a problem! 

You should have noticed that we've used two different columns for joining the names with Mr. But you can also do this in a single column. If you use the formula as below then you can do this task at once - 

=CONCATENATE("Mr. ",A2," ",B2) 

If you put the formula like this then you don't need the first two formula. Cause this one will join your names with Mr. without needing any additional column like the 2nd formula. 

 

Combining Texts in MS Excel using CONCATENATE function

 

That's the screenshot of my work. And I've also uploaded the soft copy in Google Drive. You can download it from the link below - 

 

Project File (CONCATENATE)

 

If you face any problem or notice anything wrong in this post don't be late to inform us through comment box. 

 

Stay well and stay with Marks PC Solution for cool tips, tricks and tutorials . . .


Comments

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALL...

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!! About the Activator   Name: KMSPico 10.1.5 File Size: 3 MB (Approx) File Type: Zipped Folder 100% Neat & Clean - No virus! Activating Capacity . . . KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010 Windows 10, 8.1 & 8 Hopefully this version will work for both 32 bit & 64 bit versions of Windows. Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else. Install it as trial version without any key. Use the follow...

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing. Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing.  Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout.  Click to enlarge the image Download the PDF file from the button below. Follow...