This preview shows page 1. Sign up to view the full content.
Unformatted text preview: of that cell. If the process is going to overwrite existing
data contained within those cells, Excel may provide you with a warning but relying on this degree of
data protection is risky policy. The result of clicking on the “Finish” button is that the sentence is
“dissected” into individual words placed in cells to the right and the spaces that had previously separated
those words have been removed.
Click into cell B5. This is an address cell that contains two delimiters that you want removed from the
text in the process. They are the comma and the space. Follow the path Data > Text to Columns and select
“Delimiters” and next. This time ensure that the space and comma are checkmarked and then click “Next”
or “Finish.” If you clicked “Next” you will have to click “Finish” to complete the process. This time the
data has been dissected into neat, clean cells for later processing.
Click into cell B21. Analyze this cell for delimiters and the logical choices are commas and colons.
The use of spaces as a delimiting value will break apart the alpha numbers and descriptions. While this
may leave the cost issue together, you can run another “Text to Columns” process on the cell that contains
those values later.
The fixed width option can be used to dissect one or more cells, just like the delimited option. Fixed
width will work on text and numerical values just like delimited. Click into cell B31, which contains a
numerical value. These values are summed in row 35 to prove they are numerical values. Follow the path
Data > Text to Columns and select “Fixed Width” from the options and then click “Next.” In the resulting
dialog box you see the whole number since it is not apparent to Excel how this number should be
dissected. Place your cursor between the “2” and the “3” and click once to insert a “dividing” line. Click
into the space between the “3” and the “4” to insert a “dividing” line. Since the goal is to dissect the
whole number into two number groups, th...
View Full Document
This note was uploaded on 09/19/2010 for the course ACCT 220 taught by Professor Ullmann during the Fall '10 term at University of Nebraska Kearney.
- Fall '10