How to Parse long Row entry into multiple cells ??
Using Execl 97'
The labels for each piece of the line of data would be as follows.
Year, Brand name, Length, Filter, Package, Strength, Flavor, Style,
Package Type, TAR, Nicotine, Carbon Monoxide, UPC Code1, UPC Code2
That is 17 separate labels, but they would be coming from one long
string in ONE cell, here are a few examples.
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
I'm only trying to exclude all that other junk in each ROW, but KEEP
the Name of the cigarette, style, length, and then Keep the most
important data Nicotine, Tar and CO 'carbon monoxide'.
The list is super-long and doing it line by line would take me 1,000
years, I'm not a trained typist.
Is there a formula or????
thanks again
|