Extract Text from String

[HotNumbers]

How do I extract specific Words from a cell that contains sentence. For example Cell a1 has Apple Green, Tree, In Cell B1 I want to extract only Tree

 

[hiker95]

HotNumbers,

Here is one way:

Excel Workbook
	A	B
1	Apple Green, Tree	Tree
Sheet1

 

[jim may]

Can you establish a single rule, or set of rules for what single word is to be extracted?
Can you share this rule(s)?

 

[HotNumbers]

This is eccellent, what if I do not want the last word I want for example Apple or Green, etc...
My String of words are long and I want specific words that it would match from table
Hope this make sense.
Example I want to match Parks and next to it write Parks for the others I want to Match Other and Write Other next that.... THANKS AGAIN for the prior formula

Corporate & Other
Corporate & Other
Parks & Resorts
Parks & Resorts
Parks & Resorts
Corporate & Other
Corporate & Other

 

[hiker95]

HotNumbers,

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[HotNumbers]

Sheet 1 is my Current View
Sheet 2 is my lookup table I want to locate a match.
Example is my output i Want

Excel Workbook
	A	B	C	D	E	F
1
2	CURRENT				SAMPLE
3	SHEET 1 DATA		Match			Match
4		iPad/special			iPad/special	iPad
5		Special/Home/Address			Special/Home/Address	Home
6		Online Purchase			Online Purchase	Purchase
7		Amazon Sale			Amazon Sale	Amazon
8
9
10	SHEET 2 TABLE	Table
11		iPad
12		Home
13		Purchase
14		Amazon
15
Sheet2

Excel 2007

 

[hiker95]

HotNumbers,

Can we have separate screenshots of each worksheet, showing the data in their exact cell locations?