Tab Delimiter is not functioning in Excel

Issue occurs within Item Scan in MT2070 Barcode Scanner. Issue occurs with either Code 39 or 128.

When scanning an item with the delimter set to "tab". The data does correctly transmit into a notepad file, seperating the quantity and item # with a tab.

However, this does not translate to Microsoft Excel. The quantity and the item # merges together when a tab delimter should occur in between the quantity and item #.

After programming the scanner with Add a Tab Key After Scanning a Bar Code, the issue still persists, only that it does tab AFTER both quantity and item # is input into Excel. I need the tab to occur in between Quantity and Item # and this needs to translate into Excel.

Any ideas?