Not even sure where to start with this but here goes...... Attached is a file of text downloaded from our system. It contains texts which could be one line, could be multiple lines. Unfortunately, it has the material number on only the first line and the lines are not numbered to allow for sorting. I've got the 'before' and the 'after' in the attachment. Any help with formulas (I don't know VBA) is greatly appreciated.