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 myname1 www.myname.de myname2 www.myname2.de myname3 www.myname3.de myname4 www.myname4.de myname5 www.myname5.de myname6 www.myname6.de 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 |
Quote:
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 03:09 AM. |