I am scanning in a text line into a cell on an excel spreadsheet using a barcode scanner. The information I am scanning in is UK74568230014926032006FWBX
I need to automatically split this information into the following UK745682 and 300149 and 26/03/2006 and FWBX. This information is then put into the the different columns i require and the date is formatted into day/month/year as shown.
Any help would be really appreciated


Thanks brad