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.
Step 2. Select Data from the menu, and then choose the Text to Columns button on the ribbon bar. Related Reading: How to Delete Highlighted Text in Excel. Step 3. Choose Delimited if the text and numbers are separated by punctuation, such as a comma or semi-colon, or by tabs.Choose Fixed Width if the different columns of data line up with one another. Click Next.. Step 4. Select the delimiter from the list or choose Other and type the delimiter for delimited data.hoose Delimited if the text and numbers are separated by punctuation, such as a comma or semi-colon, or by tabs. Choose Fixed Width if the different columns of data line up with one another. Click Next.. Step 4. Select the delimiter from the list or choose Other and type the delimiter for delimited data.