Ask Your Question

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

asked 2016-04-11 20:40:18 +0200

talkinggoat gravatar image

updated 2016-04-14 22:47:16 +0200

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.

edit retag flag offensive close merge delete



Did you try the option in menu Data -> Text to Column? And then select "," as seperator?

Ljiljan gravatar imageLjiljan ( 2016-04-12 08:11:51 +0200 )edit

That worked, perfectly. Thank you.

talkinggoat gravatar imagetalkinggoat ( 2016-04-14 22:46:07 +0200 )edit

I converted my comment to answer for other people searching the same solution.

Ljiljan gravatar imageLjiljan ( 2016-04-18 12:04:36 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-04-18 12:03:29 +0200

Ljiljan gravatar image

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.
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-11 20:40:18 +0200

Seen: 74 times

Last updated: Apr 18 '16