And each column can be set to a different width you

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ith column B and then copy column A to column B later if you want more practice. Click into cell B1 to make B1 the active cell. Follow the path Data > Text to Columns and you will be presented with the Text to Columns dialog box. The first choices you are presented with is “Delimited” or “Fixed Width.” Delimited means that your data can be dissected or cut apart by some specific character or event such as a space, a comma, a tab, or other, identifiable character. Fixed width means that your columns will be 1, 2, 3, or as you state, wide to accept the data. And each column can be set to a different width. You can select more than one row and accomplish the process on a range. For the data in cell B1, a pure text string with spaces between each word and words of inconsistent length, select “Delimited” and click on the “Next” button. The next dialog box will ask that the delimiting values be defined. To do this, ensure that all checkmarks are removed from the dialog box except for the checkmark for “space.” The checkmark in “Treat consecutive delimiters as one” means that if two spaces are found next to each other, they will be treated as if they were single space. This is handy and important as Excel is going to remove the delimiter in accomplishing this process. In this example, the spaces separating the words will “disappear” from the text as it is processed. At this point “Text to Columns” will give you a preview of the possible results. To advance to the next step, click on “Next.” At this point you are offered additional options – you can select a column by clicking on it and format that column in the import process to a limited number of specific formats such as general, text, or date, or you can select not to import the column at all. You can also change the starting point of the “dissection process” on this screen. If you choose a cell other then the origin cell, B2, the data will be left in B2 and “dissected” into the cell in you specify and to the cells to the right...
View Full Document

Ask a homework question - tutors are online