close

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.--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=507835Take a look at the Data gt; TextToColumns feature..........

Vaya con Dios,
Chuck, CABGx3
quot;Christianquot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()