CONVERT TABLE TO TEXT

1. Select the rows or table you want to convert to text.


2On the LAYOUT tab (next to the TABLE DESIGN tab), click CONVERT TO TEXT.




3.  In the CONVERT TO TEXT box, under SEPARATE TEXT WITH, click the separator character you want to use in place of the column boundaries. Rows will be separated by paragraph marks.

paragraph mark






tabs

others (can use any symbol to separate the data)





















reference: Office Help & Training from https://support.microsoft.com/en-my