Please see attached file for input and desired output.
If there are more than one (could be between 0-15) new numbers in the column new number, I want to split this cell and put the original number in the A-column and copy all data fields so that only one new number exist in each cell in the new number column.
Anyone know how to do this in an easy way?
Please see attached
I can't seem to get it to work, If I input:
in sheet1, the result is just the same.
Please Login or Register to view this content.
I want the result to be like this:
Ah I just saw that this macro works the other way round, I have cells with many numbers that I want to split, not the other way round.Please Login or Register to view this content.
Sorry if I was unclear
Last edited by Snajder; 12-06-2012 at 07:37 AM.
Snajder,
Yes, it was the opposite code. I realised this after I posted the code and just got back to my PC.
Try this
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks