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

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

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.


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=507835

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

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