Forum Discussion

Miriam_Ferber1's avatar
Miriam_Ferber1
Copper Contributor
Jan 21, 2019

Convert Table to Text

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

  • Miriam_Ferber1's avatar
    Miriam_Ferber1
    Copper Contributor
    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.
  • Ayman_Hassan's avatar
    Ayman_Hassan
    Brass Contributor

    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.

     

     

Resources