This preview shows page 1. Sign up to view the full content.
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
- Fall '10