Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find a text in a string without giving the position of the
My requirement are
I want to find a particular text in a string with out giving the position of the text . I believe that if we use find and search we have to give the text position for the particular text. Can anyone guide me what should be the function used for getting this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find a text in a string without giving the position of the
Post example(s)
-- Don Guillett Microsoft MVP Excel SalesAid Software "Sreekanth" wrote in message ... My requirement are I want to find a particular text in a string with out giving the position of the text . I believe that if we use find and search we have to give the text position for the particular text. Can anyone guide me what should be the function used for getting this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find a text in a string without giving the position of the
No, the "start position" in =FIND() is not the position of the text you are
looking for (why would you need to find it if you know where it is?), it just allows you to start looking in a different position. If you are searching the entire cell, just leave it out. for example: A1 = "look for this text" =FIND("this",a1) will result in 10, because what you are looking starts at the 10th character. "Sreekanth" wrote: My requirement are I want to find a particular text in a string with out giving the position of the text . I believe that if we use find and search we have to give the text position for the particular text. Can anyone guide me what should be the function used for getting this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return a character at a certain position in a string of text | Excel Worksheet Functions | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
find number position in excel text cell | Excel Discussion (Misc queries) | |||
find nth position of a string | Excel Discussion (Misc queries) | |||
find position of a number in a string | Excel Worksheet Functions |