Hi guys. Is it possible to split columns at a particular character.
I have table with one column and multiple rows, where different columns are indicated with | sign.
How to split column where | occurs in the entire table.



Thank you so much!

Edit: Table is in MS Word

Yes. Convert the whole table to text. Then convert text to table using '|' as the character that marks columns.

Thank you, Slay. Some rows separated with - and the table is pretty complicated to convert. So I am manually entering the data in a new table.

I would greatly appreciate if you could help me with one more problem.
There is one table in the document. Each page has 62 rows and the table continues.
I made a macro to hide top, left and right borders of the first row and bottom, left and right borders of the last row of the page.

How to put this macro in a loop which would repeat for total number of pages?
How do I assign value of total number of pages to an integer?
Thanks again!

Is it

a. a single word table that spans multiple pages or

b. a single table that you have split into multiple word tables so that each word table fits on a page.