On Fri, 20 Mar 2009 07:45:42 -0700, Gord Dibben <gorddibbATshawDOTca
sayd the following:

I'm also not sure after re-reading your original.

Is the sample data

cell a1 = 2005 BASIC KING F SP FULL-FLA S 15 1.1 15 0 286212 9 BJ4X05
cell a2 = 2005 BASIC 100 F SP FULL-FLA S 15 1.1 16 0 286232 3 BJ8X05
cell a3 = 2005 BASIC 100 F SP LT S 10 0.8 13 0 286272 1 BX8X05

what you have or what you want?


Just before "286212 9 BJ4X05" there is the Nicotine, Tar and CO
'carbon monoxide' listed in each row.

I'm trying to extract the Brand Name, style,lenght of cigarette and
then ONLY extract the Nicotine, Tar and CO for that brand in that ROW.


I don't know how to explain it any better than that, can someone
help???????????