Convert Table to Text

Copper Contributor

How do I remove the table and convert it to text in Excel 2016? 

2 Replies

You need to select any cell in the table so the "Table Tools Design" tab is shown.

Then select "Convert to Range" from the "Table Tools Design" tab.

 

converttorange.jpg

 

I wasn't sure whether the cells were part of a table as I did not create this sheet. I was told it was a table but could not see table attributes.
I then marked the cells and so I could creat a table. Then I followed your instructions. This solved the issue.
Thank you.