Extract cell contents to multiple rows

Hello all.

I have modified the following code provided by StephenR to extract the contents of a cell into separate rows. This works fine for numbers in the cells, but I have come across some letter-number combinations that crash the code. I need to extract the number portion of this combination to a new row. For example, if the cell contains AB1234, AB1235, 001236 I need the code to copy the entire line three times and paste just the numerical portion in column E just like it is doing for the rest of the spreadsheet.

Any help would be appreciated. Thanks!!

Please Login or Register  to view this content.