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.
SHARE SHARE TWEET EMAIL. Splitting a very long column into multiple cells can make the difference between an easy-to-read Microsoft Excel document and one with data that is poorly structured. In the latest versions of the software, you can split the data in a long column using a feature available in the Data menu.lick DATA and then select Text to Columns to open the Convert Text to Columns wizard. Step 3. Select the delimiters you want to use for splitting your data. You can choose between Tab, Semicolon, Comma and Space, but you can also create custom delimiters.