Boopathi - Thanks for the suggesstion.
That works to an extent with the cells which are 6 characters with no spaces, IE E152RZ BUT does not return enough characters on 7 digit AA10 1AA or 5 digit A11AA. Therefore as the list cannot be sorted to group all the issues in blocks it still involves me scrolling through the list manually and changing the formula.