You are Welcome Mahesh!!
On Thu, Dec 24, 2009 at 8:27 PM, mahesh parab wrote:
> Hi Praveen
>
> Thank you so much ! it's amazing , i appreciate your knowledge & help.
>
> On Thu, Dec 24, 2009 at 11:19 AM, kvc praveen kumar > wrote:
>
>> Hi Mahesh,
>>
>> Use this function along with the Exactwo
Hi Praveen
Thank you so much ! it's amazing , i appreciate your knowledge & help.
On Thu, Dec 24, 2009 at 11:19 AM, kvc praveen kumar wrote:
> Hi Mahesh,
>
> Use this function along with the Exactwordinstring function.
>
> Function checkthis(Text As String, rng As Range)
> For Each entry In rng
Hi Mahesh,
Use this function along with the Exactwordinstring function.
Function checkthis(Text As String, rng As Range)
For Each entry In rng
result = ExactWordInString(Text, entry.Value)
If result Then
checkthis = entry.Offset(0, 1).Value
End If
Next
End Function
Now in cell h2 write the formu
Dear All
i need help to modify below mention user define function. i got this code on
below mention link.
i herewith attach the excel sheet. I will appreciate any help on this.
http://spreadsheetpage.com/index.php/tip/is_a_particular_word_contained_in_a_text_sring
I want to modify this user defin
