Merge columns to replace existing columns. In Query Editor, ensure that the columns that you want to merge are of Text data type. Right-click a column header, and select Change Type > Text from the context menu. Select two or more columns to be merged. Press the CTRL key, and then click on the column headers to select the columns that you want to merge.
Normally we figure out someone's age with current date subtracting the given birth date. So does it in Excel. Step 1: Enter current date in a blank cell, such as 2016/4/7 in Cell B2. Step 2: In another blank cell (says cell C2), enter the formula =INT((B2-A2)/365), and press the Enter key.
Cancer Dates: June 21 to July 22. Cancer dates in astrology are typically from June 21-July 22. If your birthday falls in this date range, you most likely have a Cancer Sun sign. Although Cancer horoscope birth dates can change depending on the year, these are typically the Cancer calendar dates. For about 30 days each year, the Sun travels through the part of the zodiac occupied by Cancer. June 21-July 22 is typically the Cancer birth date range. Occasionally, the Cancer start date will be a day earlier on June 20, or the Cancer end date will fall a day later on July 23. Cancer is the fourth sign of the zodiac, which contains 12 signs in total.