Dissect textbox string

i'm trying to enter data into a textbox and then have that data split up into rows (3 columns per row). The data that i'm entering into the textbox is being pulled from another program that consists of 5 columns. so essentially if i just open a blank worksheet and paste the data the first two columns are blank. (not sure if that is pointless or not in this situation.)

the value of the empty columns appears as the following symbol - 

Its hard to show you here because when i copy and paste the info it puts it as 5 columns (even in notepad)

this is the value of the textbox if i enter the value of the textbox into one cell is as follows (symbol equals the square symbol from above)

symbol symbol 12091216212250 symbol 2012-09-14 16:30:00.0 symbol Doe, John symbol symbol symbol 12091216212250 symbol 2012-09-14 16:30:00.0 symbol Doe, John symbol symbol symbol 12091216212250 symbol 2012-09-14 16:30:00.0 symbol Doe, John symbol

basically i want three columns of data from this to look like this...

12091216212250 2012-09-14 16:30:00.0 Doe, John
12091216212250 2012-09-14 16:30:00.0 Doe, John
12091216212250 2012-09-14 16:30:00.0 Doe, John


another way to put it is i'm trying to get rid of the two blank columns at the start of each row of data. but i'm also needing the first number in its own array value (maybe) so i can check it that number exists.

i've probably confused everyone or make no sense, but if you can help in anyway i'll try to help you understand better.

i made a quick example of what i'm talking about to try and help

ok...made a better one

sheet 1 shows the data and how it appears as a variable in VBA, with the funny square symbols

sheet 2 is how i want it to look

thanks, i'm going to play with this some. from a quick view i think i may be able to take it from here.

your a life saver. one question though about the formula. What is the "h", "i", "j" referring to

its possible as i'm a little scatter brained right now.

your code above has gotten me to the point that i can take over from here, but i would like to learn exactly what your code does, if you can break it down for me.

thanks a million!!!