I have 2 issues I am trying to workout on some SharePoint Lists. I was hoping I could get a little help as my developer skills are just now developing beyond OTB solutions.
Issue 1: I have seen a few fixes on this through my searches, however most of what I find have been half answers. I have a SharePoint list I have exported to excel. This list has a few lookup columns to pull names from our client and personnel directories. It also pulls what appears to be the Record ID along with the value into the excel. I cannot have these export along side the names.
Example: J. Rigotti;#60 J. Shamieh;#131 S. Dearborn;#116
Issue 2: With the same list above, I am having issues getting the columns to export in the proper order in the excel. They are all correct within the browser exactly how I need them. However on the excel they are a mess. Can I organize the excel columns prior to the export?