Using the MID function, help?

[sloppy]

<table border="0" cellpadding="0" cellspacing="0" width="175"><col style="width: 131pt;" width="175"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 131pt;" width="175" height="20">PKT SQ_TURQ_CREW</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">SOHO_TURQ_T</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">STONE_CHARCOAL_CREW</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">SOHO_WHITE_CREW
<table border="0" cellpadding="0" cellspacing="0" width="175"><col width="175"><tr height="20"> <td style="height: 15pt; width: 131pt;" width="175" height="20">GUCCI_RED_ZIP_UP</td> </tr></table>
I need to find a formula that will just show the color name. Example: Red Im pretty sure you use MID function but the multiple underscores are confusing me. Any ideas?
</td> </tr> </tbody></table>

 

[hiker95]

sloppy,

Excel Workbook
	A	B
1	PKT SQ_TURQ_CREW	TURQ
2	SOHO_TURQ_T	TURQ
3	STONE_CHARCOAL_CREW	CHARCOAL
4	SOHO_WHITE_CREW	WHITE
5	GUCCI_RED_ZIP_UP	RED
6
Sheet1

The formula in cell B1, copied down:

=MID(A1,FIND("_",A1,1)+1,FIND("_",A1,FIND("_",A1,1)+1)-FIND("_",A1,1)-1)

 

[Smitty]

Welcome to the Board!

Even though it's a slightly different topic, it's essentially the same dataset, so please stick to your Original Thread.