finding text
 

Is it possible to code a find to determine if any part of
a value is in a text for instance:

=RIGHT(cell,3) xxx123 gives 123

is it possible to just code to find 123 in a text

finding text
 

=FIND("123",cell)

"Fish" wrote in message
...
Is it possible to code a find to determine if any part of
a value is in a text for instance:

=RIGHT(cell,3) xxx123 gives 123

is it possible to just code to find 123 in a text

finding text
 

Will this work?
=RIGHT(D4,LEN(D4)-FIND(123,D4)+1)

--
Don Guillett
SalesAid Software

"Fish" wrote in message
...
Is it possible to code a find to determine if any part of
a value is in a text for instance:

=RIGHT(cell,3) xxx123 gives 123

is it possible to just code to find 123 in a text

finding text
 

if instr(1,cell,"123",vbTextCompare) 0 then
msgbox "contains 123"
End if

if cell like "*123*" then
msgbox "contains 123"
End if

--
Regards,
Tom Ogilvy

"Fish" wrote in message
...
Is it possible to code a find to determine if any part of
a value is in a text for instance:

=RIGHT(cell,3) xxx123 gives 123

is it possible to just code to find 123 in a text

finding text
 

I guess you wanted a worksheet formula

=if(countif(cell,"*123*"),"found","not found")

is another to add to the collection.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
if instr(1,cell,"123",vbTextCompare) 0 then
msgbox "contains 123"
End if

if cell like "*123*" then
msgbox "contains 123"
End if

--
Regards,
Tom Ogilvy

"Fish" wrote in message
...
Is it possible to code a find to determine if any part of
a value is in a text for instance:

=RIGHT(cell,3) xxx123 gives 123

is it possible to just code to find 123 in a text