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?
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