![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
![]()
Hi
You can import a text file into Excel and specify the delimiters in excel from your text file. As for formatting it will use the default formatting in your worksheet. Follow these steps: Click on the Data menu in your worksheet. Click on From Text Navigate to your text file Click on Import Choose Delimited Click on Next Choose the delimiter used in your text file Click on Finish Hope this helps. Good luck. Tony |
#2
|
|||
|
|||
![]() Quote:
But the final shape appear in an appropriate format |
#3
|
|||
|
|||
![]()
Hi
Can you explain more clearly what you are expecting when you import to Excel from a text file. Tony |
#4
|
|||
|
|||
![]()
In fact I've got a text file from the DOS system I work it in my work, which is a columns without breaks, such as model and serial and Qty want when converted to Excel file data will be in the form of columns
|
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
jyfuller | Excel | 10 | 06-19-2013 05:31 PM |
![]() |
teddysika | Excel | 1 | 11-22-2012 06:06 AM |
![]() |
fuchsd | Word | 6 | 10-25-2011 05:52 AM |
How to restore original data format - from a .pdf file to Excel columns | KIM SOLIS | Excel | 1 | 09-18-2011 10:49 PM |
Convert a file from HTML to WORD format weblayout view | gtselvam | Word | 0 | 12-02-2008 03:53 AM |