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.

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