imported doc from pdf file, want to seperate text & date in cells

i want to sort the text copied from a pdf file
but every line saved in one cell, is there a way to split the cells or
filter the numbers out?
txs

Try saving your text file as a text file (*.txt) first, using Notepad or some other text editor. Then from Excel, Open the file (selecting file type txt), select the delimited txt option, and use a space as the delimiter.

Take a look at the Data > TextToColumns feature..........

Vaya con Dios,
Chuck, CABGx3



"Christian" wrote:

> i want to sort the text copied from a pdf file
> but every line saved in one cell, is there a way to split the cells or
> filter the numbers out?
> txs
>