| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked cells and text boxes | Excel Discussion (Misc queries) | |||
| Saved ungrouped cells to a text file | Excel Discussion (Misc queries) | |||
| can I display the file name of the imported text file in another c | Excel Discussion (Misc queries) | |||
| problem working with time data imported from text file | Excel Worksheet Functions | |||
| Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
Linear Mode
