How do I remove all characters in a string before the first occurance of a certain word?

Hi,

Please see the attached example Excel sheet. In the 'B' column on the 'BEFORE' sheet, notice there is junk test placed before the word 'Summary'. I need a VB macro that removes the junk text from each cell so the end result is as shown in the 'AFTER' sheet. The range of columns this would apply to could vary.

mvem

Solution: How do I remove all characters in a string before the first occurance of a certain word?

mvem,

Have you had a look at the file I sent you. You find that it leaves no errors in the list after it has removed the extra characters.

Patrick