Level 1

open sales order report by item detail export Excel item# and item description become combined field

When I  create an "open sales order report by item detail"  and export to  Excel the item# and description combine into one field i.e item#(description). I need to export to Excel a field with only the item#. I don't need the description.