When exporting to Excel there are sometimes blocks or squares in the result.

• Uncategorised views should be used, for best results.
• Select the rows you want to export , or select none, (expand any collapsed rows), if you want the lot.
• Press Export and select type Lotus 1-2-3 file .
• Put it filename.WK1
• Open up Excel, open the file, change type to Lotus WK* files.
• The data should be loaded.
• If you have annoying black squares in the data, use the formula to clean them up.
• Make a note of the top left cell which has the first value in which you wish to clean up, maybe A1 or A2.
• At the bottom of the worksheet, click on a left hand side blank cell.
• Click on the = sign in the formula bar below the Bold Italics Underline smart buttons and above the worksheet.
• Enter "CLEAN(A2)" Substitute A2 for the first cell which has data in, noted above.
• Now extend the cell along to the full width of the worksheet.
• Now extend the cell down to the full width of the original worksheet.
• You should now have a CLEANED version of the worksheet.
•  

Alternatively use the code below in lotusscript to remove the squares or blocks.

While Instr(temp, chr$(10) )
temp=Left(temp, Instr(temp, chr$(10) )-1) & "%20" & Right(temp, Len(temp) - Instr(temp, chr$(10)))
Wend

might have to do it with chr$(9) as well