How do I remove a table format without losing the data? All I want to keep is the data inside the table.
Here's a useful reference for you. Scroll down to #23 on this list for the direct answer to your question. https://exceljet.net/excel-tables
But take the time to acquaint yourself with the other pointers about Tables. You might even end up deciding to keep your data in that format. Fortunately (for you and me) you can recreate it as a Table after "un-tabling" it.