Copy data from a string from one cell and paste into a different cell

[dwhite30518]

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?????

[GaidenFocus]

There is a left right function in VBA, used in exactly the same way.

Please Login or Register  to view this content.

[dwhite30518]

Thanks!

What is the best way to make this formula loop through each row to until that last populated row?

[arlu1201]

Try this

Please Login or Register  to view this content.

[dwhite30518]

Thanks!

That code worked perfectly!

Is there a way that I can only have this formula work if it contains "IM"?

[arlu1201]

Updated code

Please Login or Register  to view this content.

[dwhite30518]

That is BEAUTIFUL!!! Works perfectly!!!

I have noticed that apparently I have some carriage returns within the cells. How can I trim/remove those within this code?

[arlu1201]

I have edited the code in post 6. Let me know if it works.

[dwhite30518]

Didn't work.

[arlu1201]

Do you have a sample of the data?

[dwhite30518]

I have uploaded a sample of what I am trying to work with. The cells highlighted in yellow are the cells with the carriage return.

[arlu1201]

Since you are already working out the carriage return issue in this thread - http://www.excelforum.com/excel-prog...with-text.html and its an additional part of this thread, i would suggest you mark this solved and attach your file in the other thread.

This will save you from the threads being flagged as duplicates.