This time ensure that the space and comma are

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: 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.

Ask a homework question - tutors are online