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;
- Aug 28 Tue 2007 20:39
imported doc from pdf file, want to seperate text amp; date in cells
close
全站熱搜
留言列表
發表留言