Hi
I have a one row data, contain only numbers
I want to separate the data into rows and cells
I attached a file with a sample of the data and colored the data which I want split to the table in the second sheet of the file
If you need a clarification don't hesitate to ask
I appreciate your helps and thanks in advance :D
Last edited by A7md; 10-12-2011 at 11:08 PM.
Phew !!! such a long number. Is it obtained through some concatenation?
1) The coloring doesn't exist in your original data?
2) Your string is 450 digits long... you always want to split in the exact same number of digits?
3) Or is your string of any length, and we need to break each set of 50 characters as shown?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This splits your numbers and places then the correct places.
Dont know bout keeping the formatting.
Steffen Thomsen
Please Login or Register to view this content.
this is just a sample, its to much longerOriginally Posted by arlu1201
1- No, I colored to be clear
2- No, this is just a sample
3- exactly, 50 characters in row
thannx for your interest
thanx a lot Steffen, its works, but not correctly split to the table.This splits your numbers and places then the correct places.
Dont know bout keeping the formatting.
Steffen ThomsenPlease Login or Register to view this content.
yes it's split correctly but as i said the formattings gone.
Those splits that arent long enough needs an amount of 0 in front of it.
Steffen Thomsen
This should work!
Steffen ThomsenPlease Login or Register to view this content.
* Edit
Let me know if it's working for you
actually I don't need the formatting
I attached the file after add and run the macro
it should be :
No.1: 6 digits
No.2: 4 digits
No.3: 13 digits
No.4: 11 digits
No.5: 16 digits
this one works with mePlease Login or Register to view this content.
thanx a lot Steffen
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks