Splitting cell contents by lines (2)

[oteixeira]

Hello to all,

Yesterday I had an excellent help from “nilem” forum expert on post “Splitting cell contents by lines”, which I’m transcripting:
Column B contains many lines of numbers, as per the following example:
Line1 111222/145251
Line2 333115
Line3 777555/154154
Line4 888999/115116
Line5 110110
Line6 110115
Line7 620260/145521

So numbers are always 6 digits long, sometimes separated by "/". I need to pass all data to columd D, in sets of 6 digits. In the present case all need to obtain 11 lines of all sets of 6 digits, without the slash.

The solution that nilem gave me works fine on a single worksheet, however, I needed to modify it because the destination cells are on a different worksheet. On this little bit modified code on line:

Please Login or Register  to view this content.

i’m getting the error: “Application-defined or object-defined error”
Can someone please give me some help to solve this?
Many thanks in advance
Here’s the code:

Please Login or Register  to view this content.

[GC Excel]

Hello,

Try this code :
(make sure to change the source / destination cell if required)

Please Login or Register  to view this content.

[skywriter]

If you can post a sheet post it, but you say your data is in column B, but your code is:

Please Login or Register  to view this content.

This is where the code is looking for the data from. So if you data is in column B change the D2 to B and whatever row your data starts on. There might be other problems but I'm not good enough to figure that part out without an actual worksheet. Double check your sheet names are spelled right and also that there is not a space after the sheet name. Sometimes when you look at the tab you don't know there's a space after the name unless you choose to rename the tab and then you will notice a space between your cursor and the last character in the sheet name.

[oteixeira]

Hi GC.
Unfortunately, it produces the same error. Please note that source of date has to be "D2".
Thanks
Octavio

[skywriter]

Hi GC.
Unfortunately, it produces the same error. Please note that source of date has to be "D2".
Thanks
Octavio

So this is a typo?

Column B contains many lines of numbers

If your numbers are in column D, then change the 2 after the word "Count" in the code to a 4 so it looks like this.

Please Login or Register  to view this content.

[GC Excel]

Unfortunately, it produces the same error. Please note that source of date has to be "D2".

As I wrote in my answer : (make sure to change the source / destination cell if required)

Probably that skywriter suggestions will work, if not please post your file.
Thanks,

[oteixeira]

Skywriter, thanks a lot. It worked perfectly. Many kudos to you.
Octavio

[skywriter]

Thanks for the rep. points and the feedback.

Please mark this thread as solved.

Click the Thread Tools drop down box above your first post and choose solved.