Hi There,

I am new to the forum, so sorry if below is not correct.....

I have a spreadsheet with free text comment box dialogue in Column I.
Within some of the comments are auto text strings "Resurrected from ######" (###### represents a 6 digit job number)
There can be multiples of these strings in each comment, surrounded by other text.

Is there some VBA that can pick out each of the 6 digit job numbers, and copy them into seperate cells to the right??

May be asking for too much??