Hi, This is David,

Here is one of my crazy excel Project, I Searched on the Archive for code to be Applied on This one
But with no luck.. (TBH i'm stuck )

There will be 2 Option

Option 1 :
What I need to do is to Split in to 3 Parts a String with 36 Numbers Library (not sorted)
Each Split will be divided in 12 Numbers and Copy it in Specific Cell


Option 2 :
What I need to do is to Split in to 3 Parts a String with 36 Numbers Library (not sorted)
Each Split will be 18 Numbersand Copy each Block of Numbers In Column C6 to C38
Note this part of Copy to C6 to C38 I think i can handle it



Here are the 10 String.

______________________________________________COLUMN L
R:6-->13-03-18-28-30-05-25-11-27-34-04-17-22-35-24-21-26-15-10-01-06-07-12-16-19-32-33-20-29-02-08-31-36-09-14-23
R:7-->03-04-05-11-13-17-18-21-22-24-25-27-28-30-34-35-01-02-06-07-08-16-19-20-23-26-29-31-33-15-09-12-14-36-10-32
R:8-->09-01-05-06-12-15-29-33-02-03-04-07-08-10-11-13-14-16-17-18-19-20-21-22-23-24-25-26-27-28-30-31-32-34-35-36
R:9-->05-15-18-21-08-22-30-14-23-26-03-06-11-13-16-20-28-31-32-34-29-35-36-02-04-09-25-33-24-10-12-07-17-27-01-19
R:10->04-05-11-13-17-19-21-22-24-26-27-28-29-30-31-34-35-02-06-07-08-09-12-14-20-23-33-36-15-32-03-18-25-01-16-10
R:11->01-02-05-07-08-09-11-12-13-14-16-20-21-22-23-25-26-27-29-30-34-35-36-04-06-17-18-19-24-28-31-33-15-03-32-10
R:12->02-29-07-32-17-28-06-11-26-27-34-04-23-35-05-13-19-22-30-31-21-24-01-10-12-15-16-08-09-20-03-14-18-25-33-36
R:13->26-01-16-18-19-14-15-20-03-12-21-25-31-29-09-10-32-08-33-07-13-23-30-34-02-05-11-17-36-04-06-22-24-27-28-35
R:14->16-18-21-23-34-07-02-03-06-08-11-17-29-05-10-35-15-19-20-26-28-32-12-22-27-36-09-30-24-33-25-04-14-31-01-13
R:15->09-10-12-14-15-26-31-32-33-36-08-19-29-20-16-21-28-27-13-02-03-07-17-04-18-35-06-11-22-23-24-34-05-30-25-01

To make clear the example, i'll explain How using the First String R6 + Col L

Option 1
======

a-.R:6->13-03-18-28-30-05-25-11-27-34-04-17- 22-35-24-21-26-15-10-01-06-07-12-16-19-32-33-20-29-02-08-31-36-09-14-23

b-.R:6->13-03-18-28-30-05-25-11-27-34-04-17-22-35-24-21-26-15-10-01-06-07-12-16-19-32-33-20-29-02-08-31-36-09-14-23

c-.R:6->13-03-18-28-30-05-25-11-27-34-04-17-22-35-24-21-26-15-10-01-06-07-12-16-19-32-33-20-29-02-08-31-36-09-14-23


a-. Extract FIRST 12 Numbers and i would like to Copy or move to R6 Cell C
b-. Extract MIDDLE 12 Numbers and i would like to Copy or move to R7 Cell C
b-. Extract LAST 12 Numbers and i would like to Copy or move to R8 Cell C

And So On with the Others 9 String


Option 2
======
a-.R:6->13-03-18-28-30-05-25-11-27-34-04-17-22-35-24-21-26-15- 10-01-06-07-12-16-19-32-33-20-29-02-08-31-36-09-14-23

b-.R:6->13-03-18-28-30-05-25-11-27-34-04-17-22-35-24-21-26-15-10-01-06-07-12-16-19-32-33-20-29-02-08-31-36-09-14-23

c-.R:6->13-03-18-28-30-05-25-11-27-34-04-17-22-35-24-21-26-15-10-01-06-07-12-16-19-32-33-20-29-02-08-31-36-09-14-23


a-. Extract FIRST 18 Numbers and i would like to Copy or move to R6 Cell C
b-. Extract MIDDLE 18 Numbers and i would like to Copy or move to R7 Cell C
b-. Extract LAST 18 Numbers and i would like to Copy or move to R8 Cell C

And So On with the Others 9 String

Note : as i said, i Think i can handled with small formula the Copy tinghi to the Column C6 to C38


Thank you very much



Best Regards

David