Hi Marie,

If the text is in a consistent format, you could enter a formula into

each of the columns to parse the text, or use the text to columns macro

and use period and space as the delimiters.

For the sample text these formulae will work:

=mid(a1;1;find(".";a1)-1)

=mid(a1;find(".";a1)+1;find(" ";a1)-find(".";a1)-1)

=mid(a1;find(" ";a1)+1;99)

The macro would have to be downloaded and installed first. You can

probably find it by searching the OOo web site.

tc

[hidden email] wrote:

>Dear all,

>In calc (2.0), I'd like to rewrite the text of one column (i.e. "1.10 m")

>into several different columns (i.e. 1 / 10 /m ).

>Is there a simple way to do it?

>Thank you for your help

>

>Marie Charlotte ANSTETT

>

>

>---------------------------------------------------------------------

>To unsubscribe, e-mail:

[hidden email]
>For additional commands, e-mail:

[hidden email]
>

>

>

>

---------------------------------------------------------------------

To unsubscribe, e-mail:

[hidden email]
For additional commands, e-mail:

[hidden email]