Ask Your Question
1

convert text to table, with rows

asked 2017-08-25 13:19:07 +0100

ciaron88 gravatar image

when i try to convert a block of text, with a , as a separator it puts the text into a table with 1 row and x columns. i want the table to be x rows and 1 columns. how is this done?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2017-08-25 16:04:00 +0100

Grantler gravatar image

updated 2017-08-25 16:07:48 +0100

Use FIND & REPLACE (activated Regular Expressions):

SEARCH FOR ,

REPLACE (ALL) WITH \n (i.e. paragraph)

Then apply TABLE menu > convert TEXT TO TABLE

Each paragraph is converted to a new row, as desired.

Cheers

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-08-25 13:19:07 +0100

Seen: 1,097 times

Last updated: Aug 25 '17