Concatenate Excel - GoTechTalk


Sunday, May 2, 2021

Concatenate Excel

By Sudarshan Yerunkar |  | 🛍 Support me with your Amazon purchases: | Posted on 02nd May 2021.

Concatenate Excel

Concatenate Excel

Hey everyone my name is Sudarshan and today I want to show you how you can concatenate text in Microsoft Excel but before going ahead request you all to please support me with your Amazon purchases by following this link

Concatenate, what does that even mean??

Well imagine that you have two columns of data and you want to bring them together that's what concatenate means you want to connect those two pieces of data together or you basically join data together it's actually a lot easier than you think and the really sad thing I I've had people reach out to me telling me “you know I spent maybe the last hour and a half going through these two columns in Excel and then taking the first column and pasting it in with the second column” that is a waste of time you don't have to do it manually the whole reason you use a spreadsheet program is because it automates it for you.

All right well enough wasting time now I'll show you how to do it.

So on your PC using Microsoft Excel and you have this sheet is conveniently set up where you need to use in concatenation. For example, if you have this column "first name" and second column "last name" and you want team to be merged or join together but it goes down all the way through let's say you're working with thousands and thousands of rows of data or even just 50 rows of data take a lot of time to do that by hand, so let's figure out how we could have Excel do this for us. now what traditional way of doing this is by clicking on the function option right up in menu bar and type in concatenate usually see the result but here I'm going to show you a little trick that makes this even quicker if you don't remember the word concatenate what you can also do is you could use this my favourite sign or my favourite symbol The Ampersand, you could also use this to do a concatenation so how do we do that well just type in =A2&B2 and if you hit enter it'll combine those two, so it's a little bit easier where you say hey this and that bring them together but you'll notice though we have lost that space in between first name and last name so how do I get the space in, so what we are going to do is =A2&" "&B2 there is space between the quotes and this is the formula now hit enter and there you'll see it properly.

what I wanted to do is just show you how you can very easily concatenate or join together multiple texts or strings of text in an easy way in Excel so especially let's say if you have thousands of rows or thousands of pieces of strings that you need to bring together you can very easily do that with the Excel concatenate function.

No comments:

Post a Comment