Hi,

I have some worksheets that have the following type of data.

****DATA***** ****DATA***** ****DATA***** ****DATA*****
****DATA***** ****DATA***** ****DATA***** ****DATA*****
****DATA***** ****DATA***** ****DATA***** ****DATA*****
The required data in each string can be found by counting from the
left....or it can be found by testing for the second full stop in the string.
Each worksheet has a different number of rows. I need to take the DATA out
of each cell on the same row and concatenate it and move it to the next
worksheet, then move to the next row and repeat, and form a column of data in
the second worksheet.

any help would be great!!
Thanks in advance

Manny