LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Text file to Excel format

I have generated a report from the back end (oracle) which is in a text
format. like below(it actually comes in one line). But when i export to excel
format, I am getting the contents in different lines instead of one single
cell(the heading:activity log) due to which i am not able to user auto filter
in the ticket_number field. There will be more than 100 tickets, but when i
put filter it shows just the first ticket. Please help me out with this
issue.





Ticket_Number Activity_Log
-------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
162892 Actions Taken:
Have contacted the Development Team and they had said that it
will not consider languages other than English. When this reply was sent to
Jignesh, he said that it was not the case in other tickets(eg:
162348).


Next Actions:
I have contacted Murali again about the issue. He is currently
working on it.


Signatu
Swetha R S
Initial Ticket Status: Assigned To
Status after Modification: Work In Progress


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I save excel file in text format without columns? Tuuti Excel Discussion (Misc queries) 1 July 15th 08 06:40 PM
Keeping lead zeros in excel text format when saving as CSV file Richard James Excel Worksheet Functions 1 March 31st 08 11:30 AM
text file format to xls [email protected] Excel Discussion (Misc queries) 1 April 22nd 06 07:58 PM
Why will Excel will not save text format in a .csv file davis Excel Worksheet Functions 1 January 25th 06 05:44 PM
Date format not correct when you convert a CSV text file in Excel Scarab Excel Discussion (Misc queries) 2 November 16th 05 12:22 PM


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"