We use a handheld scanner which scans a QR code into an excel spreadsheet on the scanner.

Once the data is imported into Excel (2003) on the desktop computer it is all contained in one cell. See below for an example of the data:

Arena-17120-DFS0016306-ENCORE-STD-SEAT 2str ZIP Seat Case-10

What formula is best for breaking this information up so appears in separate cells? I had an attempt using the LEFT, RIGHT formula but struggled doing this something as long as the data we are using.

Any help would be greatly appreciated.