I have a sheet that I use to track job time using a simple barcode scan that time stamps the scan in and out. I am looking to add more information to the job for tracking but don't want to do multiple scans if it's not required.
How can I take l following example of barcode text and have it go into separate cells with one scan.
25478 Smith 55
three separate columns one barcode