dataset is in one collumn - how to split it into two c. ?
hello and good evening
have a dataset - it looks like the one below
in one column is all included
how to arrange that i have
a. in collumn 1 the names ; .... myname1 myname2 etx etc
b. in collumn 2 the websites - www.myname.de1 www.myname2.de www.myname3.de
is there a way to get there !?
i am pretty new to calc
any and all help will be appreciated
yours - say-hello-to the world
Check out the "Left" and "Right" read commands. You can make Column B the left "x" number of characters of Column A and Column C as the right number of characters of Column A. I think there is even a way to subtract a string from another string ("ABC" - "A" = "BC"), but I may be wrong.
NOW BACK UP YOUR WORK TO ANOTHER FILE.
Then in columns D and E, copy columns B and C as absolute values, NOT as references. Finally, blow away columns A, B, and C. You will be left with the two columns of data you want.
I just checked it out in OOo. If cell A1 contains (without quotes) "abcdefghijk" as text and in cell B1 you use the formula (without quotes) "=LEFT(A1; 5)", abcde will appear in cell B1. Just remember that that is a reference value, so you have to copy it to another place as an absolute value.
Try this :
In Calc, select the column in question, go to Data > Text to Columns. It will split them into two if you select 'space' as the delimiter. There are other delimiters to try too.
|All times are GMT -5. The time now is 10:28 AM.|