Forum Discussion
Excell formula help
unfortunately mathetes my data is extracted from our business program that can "convert" it to Excell. Clearly this has not helped me to be able to sort into some workable format... Very frustrating.
ttlj2 That might actually be a blessing. If it's extracted (exported) from another program, there may be a way--I'd be surprised if there isn't--to export specifically in an excel table format. See if there's an option for exporting to XLS or CSV files.......
What you've got is more of an export to print, and it does a good job of that; it just so happens that Excel can open it, but it (as you're finding) ain't useful.
So look for an export option to XLS, XLSX, or CSV.
And if that's not available, if you can post a section of it (cleaned so as not to reveal confidential or personal info) I can get the formulas started for you.