How to remove Unicode characters and/or convert OpenOffice spreadsheet cells to plaintext?
Posted
by
gonzobrains
on Super User
See other posts from Super User
or by gonzobrains
Published on 2012-05-31T01:48:34Z
Indexed on
2012/05/31
4:43 UTC
Read the original article
Hit count: 181
openoffice.org
|unicode
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
© Super User or respective owner