Good morning all!!!

I have some data that I want to pull from a string within a cell and paste into a different cell using VBA. Not sure how to do this...ideas?

Ex.

C2 contains the following...
NONSTOREDEVICE IM78546985

I want to copy from the IM to the right and then paste in cell B2. Then continue this process for each row on the worksheet.

I have used the "Right" and "Left" formulas when working with smaller sheeting. However, due to the size of this report and the fact that I am trying to speed up the time it takes me to create this report, I would like to do this using a macro.

Ideas?????