How to remove Unicode characters and/or convert OpenOffice spreadsheet cells to plaintext?
- by gonzobrains
I have an OpenOffice spreadsheet into which I occasionally copy/paste snippets from web pages. However, I need the file, as a whole, to be free of fancy formatting and non-ASCII text. Is tried highlighting cells and selecting "Default Formatting" but this still seems to keep extraneous characters even though it looks like normal text to the human eye.
If this is not possible, is there a way to at least reveal the "raw" data within a cell so that I can manually strip it?
Thanks,
Jeff