How to find a text in a string without giving the position of the

S

Sreekanth

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.
 
D

dlw

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find nth position of a string 6
How to Find Specific Text in a Text String 2
Finding a position in a Cell using a formula 11
find number position in excel text cell 5
Extracting Numerals From a Text String? 1
How to determine the value within specific cell position? 5
Return search value, not starting position 2
Excel Functions 6

Top