Hello All Experts,
I am using Office XP and have the following problem:

I have data in Col AA for examples as follows:

AA1 =Text 1 = eg John
AA2 =Text 2 = eg Johnny
AA3 =Text 3 = eg James
AA4 = Text 4 = eg Henry
AA5 = Text 5 = eg George
.....
.....
a range of unique Text Strings in AA1:AA25

I wish to select the Col A and run the macro. The macro should look up the
value in the above range in Col AA and in corresponding ColB it should have
the value extracted.
for eg.
A1 = Abraham John Joseph -- then B2 should have the value John only (as it
is in the range in Col AA)
A2 = Henry the II -- then B2 should have the value Henry only
A3 = The Junior George -- then B2 will have the value George only

In other words Col B should have atleast one value from the String in AA1 if
found otherwise it should be blank
Pls note that no two words are repeated in the String in Col A for eg..
there are no two Johns no two George and so on

Can this be achieved thru VBA or a formula. Any suggestions are requrested

Many thanks in advance
Rashid Khan