.

sure. the excel sheet is available online.

http://www.msci.com/products/indexes/sector/gics/gics_structure.html

it is the most recent excel file. 2014 one.

i could not find other operators for which i can pull out a date from a cell and text. if you know, let me know.

I finished this task with ssis.

I used sql command to import from excel.

select f1,f2 from [sheet1$] where f1 like '[0-9]%'

and do it for other columns.

put them in 2 columns with...

actually I finished this task with SSIS. it was really nasty and painful.

I did not use Right (..,..).

I put each words into an array. and got the size of the array. if the size of the array is X, I got...

I solved this task. I used script component to write VB code. with VB I could extract the text from the cell in excel and put it in array.

I...

it is reoccurring. thank you for the reply. there are about 350 rows in the excel file. I don't know if I can pick data by column with script...