If you've ever exported a Notes view into Excel, you may have found that each column in the view ends with a block character. This becomes annoying if you then have to try and get rid of them.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
In the Save As Type drop-down box in Notes, choose the option Lotus 1-2-3 Worksheet. Type in the name of the file and give it a ".wk3" or ".wk4" extension (rather than the standard ".wks" or ".wk1"). You will now find you have clean data in Excel!