Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
WordPad file convert in Excel
My company is using a system for sale tracking. The report output is
generated in WordPad file. I have lot of problem to convert WordPad file to convert in Excel on daily basis for different reports. Can It possible for just few little time to convert WordPad file into Excel for Analysis and Pivot Report. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
WordPad file convert in Excel
Normally one would use Data, Import External Data, Import Data, identify the file, identify the delimiters and whether consecutive delimiters are considered = 1, set the date format as required, and import. This, of course, depends how your data was output to you, and how you want it to be used, that is, the Format of the data you receive. With no other details the time taken could be any length. Hope this helps. -- Tarique Wrote: My company is using a system for sale tracking. The report output is generated in WordPad file. I have lot of problem to convert WordPad file to convert in Excel on daily basis for different reports. Can It possible for just few little time to convert WordPad file into Excel for Analysis and Pivot Report. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=534942 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Convert excel printout into electronic file | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
convert excel file to html file | Excel Discussion (Misc queries) | |||
Trying to convert excel 2003 to pdf file? HELP | Excel Discussion (Misc queries) |