Skip to main content

How To Use Fill Justify Function Transfer Rows to a Column In Excel

In Excel, Fill Justify function is an interesting feature that allows users to reformat text so that it fits into a pre-selected space. But do you know Fill Justify Function can transfer rows to a column Ok, let's look this excellent feature.

For example, how to transfer A1:C4 to column E, see figure below:

Transfer Rows to a Column

Getting the data

Copy A1:C4 to a new worksheet to start this tutorial.

1 2 3
4 11
12 111
333 1234 12345

Use Fill Justify Function Transfer Rows to a Column

  1. Select A1:C4.
  2. Press CTRL+C.
  3. Under the Home menu tab, in the Clipboard group, click the Clipboard button to show the office Clipboard Task Pane.
    Clipboard button
  4. Double click E1. Or select E1, then press F2.
  5. Click the item that we copied in the clipboard.
    Paste Clipboard
  6. Press CTRL+H to open Find and Replace window.
  7. In Find what box, hold down the ALT key, type 10 on the number pad, then releasing ALT. This step will enter line break symbol (ALT+10).
    Find ALT 10
  8. In Replace with box, input a space. Then click Replace All.
    Replace with a space
  9. Click Ok to close the dialogue box.
  10. Click Close to close Find and Replace.
  11. Change the width of Column E. Drag the boundary on the right side of the Column E heading until the column is only display one character.
  12. Under the Home menu tab, in the Editing group, click the Fill button, then choose Justify.
    Fill Justify
  13. Click OK to close the warning dialogue box.
  14. Under the Data menu tab, in the Tata Tools group, click the Text to Columns button, then click Finish in the Convert Text to Columns Wizard window.

Video Tutorial

Use Fill Justify Function Transfer Rows to a Column

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>