Select the cell(s) where you want the text to appear vertically. Go to the Home tab in the top ribbon. In the Alignment group, click the Orientation drop-down arrow. Choose Vertical Text from the list ...
You can split cells into columns in Excel using the "Text to Columns" tool. Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells into ...