You're done, and here are the results: Column options Highlight the full range of cells (in this case, A1 through A4).In this case, column B must be empty because the data will grow one column to the right. Otherwise, the cells will be overwritten. Make sure there are enough clear cells to accept the new values.
To remove the comma and put the country names into column B, we proceed as follows: Our example spreadsheet contains city and country names delimited by a comma: Calc will parse the text and split it apart using whichever delimiter character you choose including tab, comma, space, or semicolon. Now it is possible to also do it within existing cells. Before it was possible to import delimited text (typically comma or tab delimited) into the spreadsheet through a file or a clipboard. 2.4.0 introduces text to columns for Calc.
0 kommentar(er)
