Combining Date and Place of Birth Born in Excel

Combining and Date of Birth Place of Birth to 1 column in Access can be done easily. But if in Excel, not easy.

Why? Because we actually combine the two different cells of the format. Cells using a text format (Place of birth), while the other format selnya date (Date of Birth).

We buktikan combine with the direct use operator &, so also if you use the Concatenate operator, the result will remain the same. Failed!

Range so that the merging of text and date format appears appropriate facilities and the desired use Copy and Paste Special with the help of Word.

The steps:

1. In the Excel program, block fields, date of birth and click [Copy].
2. Move to MS Word and click on the [Edit]> [Paste Special]> [Paste] [Unformatted Text]> [OK].
3. Back to Excel, a column block (where a copy will be placed) By clicking on [Format]> [Cells]> [Number]> [Text]> [OK].
4. Moving to the Word, and the text block and click [Copy].
5. Return to Excel, then place a cell in the O7 click [Paste Special]> [Paste]> [Text]> [OK]. Now combine the results in Q7 cells by using the appropriate service & want. The same results will be obtained if you use the command = Concatenate.
6. Next live copy - paste to the range below.
7. Finally, the range to copy from the same range by using the command pairs [Edit]> [Copy] and [Edit]> [Paste Special]> [Value]. Now the fields are not used can be deleted with the [Edit] [Delete]> [Column entire]> [OK].

Source: pcplus