FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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.

Detailed explanation-2: -Split cells In the table, click the cell that you want to split. On the ribbon, select the Layout tab. Select Split Cells. In the Split Cells dialog, select the number of columns and rows that you want and then click OK.

Detailed explanation-3: -If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you rotate the data from columns to rows, or vice versa.

Detailed explanation-4: -You can use the LEFT, MID, RIGHT, SEARCH, and LEN text functions to manipulate strings of text in your data. For example, you can distribute the first, middle, and last names from a single cell into three separate columns.