Excel Formula Help.. Please?

[sloppy]

Product
​

<table border="0" cellpadding="0" cellspacing="0" width="175"><col style="width: 131pt;" width="175"> <tbody><tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt; width: 131pt;" width="175" height="21">GREY_ZIP_UP
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">PKT SQ_ORANGE_T</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">StyleCode
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">ZIP_UP
T
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> </tbody></table>I need to get the style code answer from using the product column above. I know I need to use a character function such as the RIGHT function but im conflicted because there is multiple "_".... confused?
<table border="0" cellpadding="0" cellspacing="0" width="64"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 15.75pt;" height="21"> <td style="height: 15.75pt; width: 48pt;" width="64" height="21">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> </tbody></table>

 

[VoG]

".... confused?

Yes, what do you have and what do you want to return.

 

[sloppy]

I have the Product column in my spreadsheet and i need a formula that will equal to those Stylecode answers. I used the Right function: =RIGHT(D19,LEN(D19)-FIND("_",D19)) and it returned Orange_T
d19 is PKT SQ_ORANGE_T... I just want it to show up as T and i want the other product to show up as Zip_up. Ive been confused on what formula i should use.

 

[VoG]

I have the Product column in my spreadsheet and i need a formula that will equal to those Stylecode answers. I used the Right function: =RIGHT(D19,LEN(D19)-FIND("_",D19)) and it returned Orange_T
d19 is PKT SQ_ORANGE_T... I just want it to show up as T and i want the other product to show up as Zip_up. Ive been confused on what formula i should use.

You know what you want to do. We don't. please explain as though we are idiots.

 

[sloppy]

I need ONE formula that will make GREY_ZIP_UP return as ZIP_UP and PKT SQ_ORANGE_T to return as T.

 

[sloppy]

^

 

[jolivanes]

See here
http://www.ozgrid.com/forum/showthread.php?t=152238