At 21:08 06/10/2007 -0400, Lisa Hetherington wrote:
in Excel, I can do....Data..Text to Columns
How do I do this in Calc
You need somehow to bring up the Text Import window, which allows you
to do the editing you need. Here's a suggestion:
o Select the relevant cells in Calc and cut or copy them.
o Paste the text into a text editor, e.g. Writer or (if using
Windows) Notepad. If you use Writer, use Paste Special... and select
"Unformatted text".
o Cut or Copy the material that you have just pasted.
o Paste the material back into Calc. If pasting from Writer, you
again need to use Paste Special... and "Unformatted text".
o This brings up the Text Import window. Tinker with the "Separator
options" to achieve what you need.
Of course, if you are pasting the text into Calc from somewhere else
in the first place, you need to do only half of the above, as you can
apply the editing then.
Here's another way:
o Save the sheet containing the material in Calc as a CSV file.
o In the "Export of text files" window, delete the double quote from
"Text delimiter" - so that the option is empty.
o Use Insert | Sheet From File... to import the text again.
o This again brings up the Text Import window. Adjust the options
as you require.
It would be nice if there were a way of stimulating the Text Import
window without going round the houses like this, but I don't see a
way of doing so.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
