Text To Columns in Calc?

Discuss the spreadsheet application

Text To Columns in Calc?

Postby tad » Sat Dec 01, 2007 12:13 am

In Excel, there is a data function that sends "text to columns." (Data / Test To Columns) Is that function available in Calc? If so, would you please direct me to it?

Eample of Use:

"Each of these words goes in a new column in the same row."

* The above sentence is in Column A.
* I would like to have each word sent to separate columns.
* In this case, I will chose to use the "space" between each word as the delimiter.

Would very much appreciate any help.
Tad
tad
 
Posts: 7
Joined: Wed Nov 28, 2007 6:21 pm

Re: Text To Columns in Calc?

Postby probe1 » Sat Dec 01, 2007 1:16 am

This will be implemented into OOo in version 2.4, see: http://qa.openoffice.org/issues/show_bug.cgi?id=4040

In the meantime use Text to Columns
Text to Columns wrote:
Author: Paolo Mantovani
Small macro that allows the user to separate text or data into more columns within OOo Calc Documents. This macro can deal with delimited fields (delimited by commas, semi-colons, etc) and fixed-width fields. Very similar to corresponding feature of MS-Excel(r) or 'text to table' in OOo Writer.

Latest release: Version 20070328 (April 5, 2007)
Cheers
Winfried

DateTime2 extension: insert date, time or timestamp, formatted to your needs
User avatar
probe1
Volunteer
 
Posts: 277
Joined: Mon Oct 08, 2007 1:34 am
Location: Chonburi Thailand

Re: Text To Columns in Calc?

Postby AndrewZ » Sat Jan 26, 2008 7:58 pm

Issue 4040 is implemented in OpenOffice.org version 2.4.0. A developers' snapshot is available for download now, and the final release is March 2008.
<signature>
* Did you solve your problem? Do others a favor: Post the solution
* Visit OpenOffice.org Ninja (blog) and OpenOffice.org Ninja Wiki for news, previews, troubleshooting, etc.
</signature>
OOo 3.0.X on Fedora 9 + XP
User avatar
AndrewZ
Volunteer
 
Posts: 633
Joined: Mon Oct 08, 2007 1:25 am
Location: Colorado, USA


Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests