Difficulty: Moderately Easy
Step1
Highlight the data that needs parsing. You only need to highlight the first column since all your data is in this column. This should be the same for all software programs.
Step2
Select "Data" and "Text to columns" in Excel. In Lotus, you would select "Range" and "Parse."
Step3
Click on "Fixed width" in the dialog box that comes up in Excel and then click "Next." In Lotus, you need to click on "Create" to have a format line appear.
Step4
Separate the data by placing vertical lines in the box where you want to divide the data. Double clicking will make a line disappear; a single click will add a line.
Step5
Choose "Finish" to create the new spreadsheet in Excel. In Lotus choose an "Output range" if you want to have the data somewhere else in your spreadsheet than where it is now. You then need to select "OK" to create the new spreadsheet. Your data is now parsed and will appear across multiple columns rather than the single column it was in before.