If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
|
Thread Tools | |
Display Modes | |
|
|