Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding text | Excel Worksheet Functions | |||
Finding text | Excel Worksheet Functions | |||
Finding text in a cell and returning a value based on that text | Excel Discussion (Misc queries) | |||
Finding a particular text | Excel Discussion (Misc queries) | |||
Finding Specific Text in a Text String | Excel Worksheet Functions |