Find a word and move it... [solved]

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:

  1. Select the columns you want to separate
  2. Cnd click on the following menu: “Data” → “Text to Column”.
  3. Select “,” as seperator.