How do I convert a .xls file to .asc?

  • Thread starter Thread starter Marty
  • Start date Start date
M

Marty

I need to covert a .xls file to .asc to send to another system. Based on the
explanation the recipient has given me, it sounds like what they want is a
text file with fixed width columns. They also want page breaks inserted at
each change in dept #. The data in the file will be:

Dept # (a 3-6 digit number)
Employee Name (text with the max characters = 50)
Dept Name (text with the max characters = 50)
Parent Company (text with max characters = 6)
Last TST (some values will be a date in mm/dd/yyyy format and some will be
the text "None in 2 yrs"

I am not a programmer so please provide easy to follow detailed instructions.

Thanks so much!
 

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

Similar Threads

Converting ASC to csv 1
How Can I Convert MBOX to HTML File? 2
How to convert a .msg File? 1
csv to xls formatting problem 1
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
How to maintain text characters when converting from xls to dbf f. 1
how can i convert tmp file in to xls file 5
how to export a spreadsheet with column width over 255 maximum excelallows? 4

Back
Top