| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
importing txt file!
hi all!
i am having a text file delimitted with a non printable character (like a small squre)..! while importing it into excel what should i give in the delimiter option..? any help pl..! regds! -via135 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
importing txt file!
Hi via135,
Unles you can edit the text file, you'll need to find out what character it is. It might be easier, though, to open the file in Word, for example, copy the character, then do a find/replace, pasting the copied character into the Find box, and changing it to something else. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "via135" wrote in message oups.com... hi all! i am having a text file delimitted with a non printable character (like a small squre)..! while importing it into excel what should i give in the delimiter option..? any help pl..! regds! -via135 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing TXT file from web | Excel Discussion (Misc queries) | |||
| Importing a file(s) | Excel Worksheet Functions | |||
| Importing a file | Excel Worksheet Functions | |||
| Importing a csv file | Excel Discussion (Misc queries) | |||
| Importing text file, only option to edit existing file | Excel Discussion (Misc queries) | |||
Hybrid Mode
