i want to find duplicate words from a single cell...
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
examle data cell say (A1):
<o></o>
At last night came, and she went to bed, but still she would not take off her sun-bonnet, for fear of losing the only head she had, and she lay down very sorrowfully and fell asleep.<o></o>
Required in B1 C1 D1----- there are THREE (and) in above story and i want to retrieve only those three (and).<o></o>
regards,
<o>
</o>
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
examle data cell say (A1):
<o></o>
At last night came, and she went to bed, but still she would not take off her sun-bonnet, for fear of losing the only head she had, and she lay down very sorrowfully and fell asleep.<o></o>
Required in B1 C1 D1----- there are THREE (and) in above story and i want to retrieve only those three (and).<o></o>
regards,
<o>