Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Hi, does anyone know if this is possible... I need to import some text files into excel but when I use the DATAImport external dataimport Excel seperates the data into multiple cells. I need to get it so that when the text file is imported (they aren't particualry long either, usually just 10-15 short lines), each file will be in its entirity in a single cell. I've attached an image incase that isn't particulary clear. I'm not sure if this is possible to import multiple files like this so may just have to do it manually. Many thanks in advance. +-------------------------------------------------------------------+ |Filename: Text_Import.gif | |Download: http://www.excelforum.com/attachment.php?postid=3428 | +-------------------------------------------------------------------+ -- saybut ------------------------------------------------------------------------ saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949 View this thread: http://www.excelforum.com/showthread...hreadid=374146 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format text across cells | New Users to Excel | |||
how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) | |||
multiple text files URGENT | Excel Discussion (Misc queries) | |||
importing multiple text files??? | Excel Discussion (Misc queries) | |||
Importing text files into Excel | Excel Discussion (Misc queries) |