Distribute Text Record For Free

Click in a cell, or select multiple cells that you want to split. Under Table Tools, on the Layout tab, in the Merge group, click Split Cells. Enter the number of columns or rows that you want to split the selected cells into.

Make multiple columns or rows the same size Select the columns or rows you want to make the same size. You can press CTRL while you select to choose several sections that are not next to each other. On the Layout tab, in the Cell Size group, click Distribute Columns. or Distribute Rows .

Select the cell, range, or entire column that contains the text values that you want to split. On the Data tab, in the Data Tools group, click Text to Columns. Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into separate columns.

Increase the spacing for text in a cell Right-click in the cell you want, and click Format cells. On the Alignment tab, change Vertical to Justify. Click OK. Your text is now distributed evenly inside the cell. If you change the height of the row, the text re-adjusts evenly to the new width.

With these simple steps you can control exactly where the line breaks will be. Click on the cell where you need to enter multiple lines of text. Type the first line. Press Alt + Enter to add another line to the cell. Tip.Type the next line of text you would like in the cell. Press Enter to finish up.

Change the spacing between characters Select the text that you want to change. On the Home tab, click the Font Dialog Box Launcher, and then click the Advanced tab.In the Spacing box, click Expanded or Condensed, and then specify how much space you want in the By box.

Select the text you wish to split, and then click on the Data menu > Split text to columns. Select the Space. Your text will be split into columns.