Excel 2007 in Telugu (Data tool) Part 19

The first button is Text to Columns. This button will separate words into 2 columns. To try this type you first and last name in one cell. Then click the Text to Columns button. It will open the Convert Text to Columns Wizard.The first step of the wizard has you tell Excel how your words are separated in the cell. I need to click Fixed width because I just used a space. Then click next. In the next window lets you set the column widths. You can adjust the widths by moving the arrows. When finished click next for the third window. The third window has you set the type of cell format, ie: text, currency, etc. make your selection and click finish. It will return you to your spreadsheet with all of the selected cells separated into 2 cells.
Excel 2007 Remove Duplicates Excel 2007 Remove Duplicates Window

The next button is Remove Duplicates. If you have columns in your spreadsheet that may have duplicate data you can click the Remove Duplicates button and the Remove Duplicates window will open.

In the Remove Duplicates window check the boxes next to the columns you would like the duplicate data removed. Then click OK and all duplicates will be deleted from the spreadsheet.