how to use SEARCH?

  • Thread starter Thread starter hendersson
  • Start date Start date
H

hendersson

Could someone please tell me how to use the function SEARCH in XL? I
tried the exampel in help, but it doesn´t work =((((((((
 
Place formulae in cell A1 : =SEARCH("a",C1,1)
Cell C1 contains Dave
Cell A1 returns 2 as the 2nd letter of c2 is "a". Search finds first match
and returns position of match starting at position of third parameter (e.g. 1
)

If "a" does not appear in C2, A1 returns #value

Hope this helps
 

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

problem with a macro autofilter to delet rows 6
System Date 2
Run macro from shape when runnig macro in Excel 2007 4
comparison similar rows in Excel 9
Imported data spaces 5
Delete repeated values 2
Repeat values in column A a certain number of times depending on thevalue in column B 8
Excel 2007, Windows 7 Pro 1

Back
Top