Is there a way to find a single word and move it to another column, in Calc? For example, I have a column that contains first and last names, separated by a comma. Not a problem finding the comma or the name, after, but I need to move the last name to another column.
Did you try the option in menu Data → Text to Column? And then select “,” as seperator?
That worked, perfectly. Thank you.
I converted my comment to answer for other people searching the same solution.
This can be done in the following way:
- Select the columns you want to separate
- Cnd click on the following menu: “Data” → “Text to Column”.
- Select “,” as seperator.