WordPad file convert in Excel

G

Guest

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.
 
B

Bryan Hessey

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.

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top