 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008importing .prn files
Up until a few weeks ago, when I dragged a .prn file into excel, each line would appear in a single cell. Recently, excel now parses the file into columns, based on spaces in the .prn file. I don't want this. I prefer each line in a single cell. any suggestions? thank you. You probably used Data>Text to Columns>Delimited by "space" for some other operation. Excel remembers this.........thank you much<g> Run through Data>Text to Columns with some dummy text and change the delimiter to nothing. Gord Dibben MS Excel MVP >Up until a few weeks ago, when I dragged a .prn file into excel, each line >would appear in a single cell. [quoted text clipped - 5 lines] > >thank you. Gord- thank you very much for the assistance. joel > You probably used Data>Text to Columns>Delimited by "space" for some other > operation. [quoted text clipped - 15 lines] > > > >thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.