Geekers - Microsoft Office is an installation package in which there are many programs. Examples are Microsoft Word, Microsoft Excel, Microsoft Power Point and so on. All the programs in Microsoft Office are very useful for users. Because by using Microsoft Office, you can process data, create documents, and present presentation slides.
For example, like Microsoft Word, the function of Word is to create a document such as letters, papers, or other documents. PowerPoint is a program that allows you to present attractive presentation slides with complete features and tools. And Excel is one of the mainstay programs from Microsoft Office which is capable of processing data and presenting mathematical functions in it. So that users can process a lot of data quickly.
How to Combine Places and Dates of Birth in Excel
When processing some data in Microsoft Excel, we will definitely need to combine two or more texts into one cell. An example is like combining the name of the place and date of birth.
Where the place and date of birth are in different columns, whereas we want to combine them into one column. To combine them manually, it will definitely take a lot of time and we will also feel tired when typing them one by one. Especially if the data we want to combine is in the thousands. It would be very tiring for us to type it into a cell.
But you don't need to worry anymore, because in Microsoft Excel there is a formula to combine 2 texts into 1. And here's how to combine place and date of birth in Excel.
1. Using the “&” Function
You can use the "&" function to combine 2 different text cells into 1 text in 1 cell. Here's how:
1. First, you must first open the Excel document which already contains the Place and Date of Birth that you want to combine. Here I use 3 columns, namely the first place column containing the name of the city, the second is the date of birth and the third is the place, date of birth. In the column Place, Date of Birth, later I will combine the text in the Place column and the text in the Date of Birth column in that column.
excel excel
2. Click on the column Place, Date of Birth, and type the formula or syntax as shown in the picture. Note that A2 is the cell reference for the place column and B2 is the cell reference for the date of birth column. After typing the formula, click Enter. Then the result will look like in the image below.
How to Combine Place and Date of Birth in Excel How to Combine Place and Date of Birth in Excel
3. To copy the formula from the first row in the column Place, Date of Birth, click on the first row and then type CTRL+C. After that Block all the columns that are under the first row. After that click Enter.
concatenate concatenate
4. So here are the results.
concatenate concatenate
5. If you want to format the date of birth into the name of the month, you can use the syntax in the image below. Then the results will appear in the red box.
concatenate concatenate
2. Using the “&” Function
CONCATENATE is a function from Microsoft Excel that allows you to combine two or more texts into one text. Well, here we can use this function to combine place and date of birth into one cell.
The syntax for writing this function is: CONCATENATE(text1, [text2], …) . Where in the syntax text1, text2, and so on you can fill it with numbers, text, or cell locations.
And here's how to combine place and date of birth in Excel using the CONCATENATE function:
1. Type the formula as shown below, then click the Enter button.
1 1
2. To change the name of the month into a number, you can use the formula as shown below.
How to Combine Place and Date of Birth in Excel How to Combine Place and Date of Birth in Excel
Thus the article that explains how to combine place and date of birth in Excel. Hopefully this article can be useful for you.