Split String in 3 Blocks of #s, Extract each Block to copy on specific Cell

**david gonzalez** · 02-18-2013, 08:33 PM

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

**TMS** · 02-18-2013, 09:22 PM

If the numbers are always two digits, you should just be able to use LEFT, MID and RIGHT to extract your strings.

Regards, TMS

**david gonzalez** · 02-18-2013, 09:53 PM

Hi Mr TMShucks,

I'm still Noob, and sometime i'm dummy

(smile)

You know what? i had a vague idea about to Use MID, but on my mind i tough that also need To Use FIRST and LAST

HAhahahah....(laugh about my self) And thanks to you I Realised that Is LEFT, MID, and RIGHT.. jajajjaja.. i'm so dummy..

Thank you Sir, I'm Going to Try in a lill bit.

Best Regards

David