This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.

As you type, Excel suggests the combined name. Press "Enter" to accept this suggestion and automatically combine names in all consecutive rows.