Ask Your Question

formating a row of text in calc

asked 2017-04-19 17:37:02 +0200

updated 2017-04-19 17:39:08 +0200

I have a list of information divided by tabs like this

  • 4% Chronic obstructive pulmonary disease
  • 4% Stroke
  • 4% Ischaemic heart disease
  • 2% HIV / AIDS

(after each % there is a tab)

in cmd+v it into calc

currently all information is moved to the first column

i would like to get the first block before the tab ( number+ % ) in one cell

and the next block after the tab ( hiv/ aids) in the next cell on the right

Also is there a shortcut to divide the text on the cursor position (in my example the position of the tab behind the % sign ) and move the text after this position to the next cell on the right side.

Bonus question (shortcut to to the same thing, but move text to the cell below)

And by hitting alt modifier key to move it to a newly inserted column on right side of the current cell

/new row below the current cell?

Thank you very much :)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-04-19 18:07:08 +0200

karolus gravatar image

updated 2017-04-19 18:07:42 +0200


Select the Column and do the obvious in →Data→Text to Columns…

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-19 17:37:02 +0200

Seen: 35 times

Last updated: Apr 19 '17