On 21/08/07, Andreas <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> is there a way to cut up text columns?
> Suppose you get a file where in column A is a list of text-values like:
> "01 first"
> "02 second"
> "03 third"
>
> Now I'd rather have the number part remain in column A and the text part
> in a new column B.
> "01" "first"
> "02" "second"
> "03" "third"
>
> I couldn't find such a feature in OOo, yet.
>
> EXCEL does this in its Data menue with the command "text in columns".
> It's similar to the text-file-import where one can define if the data
> has fixed width columns or is separated by some character like space or
> tab.
>
>
> Regards
> A.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
Assuming the two parts are always separated by a space:
In B1 put the formula =LEFT(A1;FIND(" ";A1))
In C1 put the formula =RIGHT(A1;LEN(A1)-FIND(" ";A1))
Note the space between the quotes in each formula
Drag (copy) the formulae down their respective columns.
The result is the numeric parts in column B and the text parts in column C
For explanations, see the Help under LEFT, RIGHT, LEN and FIND which are
inbuilt functions.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
