Filtering data in Excel

New Contributor


Thank you for reading this.

I need assistance in filtering the data copied from a pdf file to excel. I am copying a table with numeric data and headers but all of it is getting pasted to a single cell and I am unable to process it. I know the option of Text to columns but that has to be applied separately on every row.

Is there any way to sort it together in one go?original tableoriginal tablecurrent excel viewcurrent excel view

Thank you

4 Replies


I don't know if I can help, but I know that, if I may recommend, I would suggest sharing / informing you about the Excel version, operating system and storage medium.

This saves you a lot of time and effort, especially yourself :).

Welcome to your Excel discussion space!


Thank you for your understanding and patience


I know I don't know anything (Socrates)

best response confirmed by sonamvohra (New Contributor)


If you copy/paste from PDF try Paste -> Paste Special -> Unicode text.


Alternatively you may use Power Query to import table from PDF if such option available for your Excel version.

That worked!
Thank you so much.

@sonamvohra , glad to help