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 email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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!