However, this article focuses specifically on investment in financial assets. In finance, the benefit from investment is called a return. The return may consist of capital gains or investment income, including dividends, interest, rental income etc., or a combination of the two.
Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns). Press CTRL+HOME to select the first cell on the worksheet or in an Excel list.
Insert two columns to the right of the column containing the data that needs to be split. Step 2. Copy all of the cells from the original column to the first new column. Related Reading: How to Make Smaller Columns Under the Main Column in Excel. Step 3. Select the Data tab, and click Convert Text to Columns.This starts a wizard to help split the data.tep 2. Copy all of the cells from the original column to the first new column. Related Reading: How to Make Smaller Columns Under the Main Column in Excel. Step 3. Select the Data tab, and click Convert Text to Columns. This starts a wizard to help split the data.