CONCATENATE : My employer requests that I transfer a list of names from a spreadsheet to a text file. But the formatting seems strange when I copy and paste. The first and last names should be in the same column, however that would take a very long time to enter.
In our spreadsheet (Microsoft Office 2019)
It appears that we have a list of contact details. There are columns for each individual’s first name, last name, and other contact details, and each person has a row of their own.
How can we find a rapid solution to this issue?
It would take a lot of effort to manually input everything if we wanted the data from the Last Name and First Name columns to show together in the same cell. We may use the CONCATENATE function to automatically combine this values rather than doing it manually.
What it does
Concatenation is basically another word for combining or joining together. You may merge text from various cells into a single cell by using the CONCATENATE function. We can use it in our example to combine the content from columns A and B to get a combined name in a new column.
We must add a new column to our spreadsheet before we can begin coding the function in order to save this data. We’ll place it in our example to the right of column B.
Writing the program
Now that our function is prepared, enter it into cell C2. We’ll begin as normal with the equals sign (=), then the function name, and finally an open parenthesis:
You may substitute the new CONCAT function for CONCATENATE in the most recent version of Excel (Microsoft Office 2019.) . The two operations are identical.
We are now prepared to start our arguments. The parameters specify which cells should be combined in the CONCATENATE function. In our example, we’ll transform each of the text in cells A2 and B2 into an argument in order to combine them:
=CONCATENATE(B2, A2) (B2, A2)
Let’s execute this function now, OK?
You may have noticed that there isn’t a gap between the first and last names. This is due to the fact that CONCATENATE will only combine the items you specifically instruct it to combine. You must instruct CONCATENATE to add any data you wish in the cell, such as punctuation, spaces, or other information.
We may just add another parameter and add a space: ” ” (two double quotes around a space). Ensure that commas are used to separate the three arguments:
=CONCATENATE(B2,” “,A2) (B2,” “,A2)
Perfect! The formula may now be copied to the other cells in this column by using the fill handle.
I’m done now! We are prepared to return this to our friend: