Excel - 'Find' function doesn't work properly 1

[pho01]

'Find' worksheet function doesn't work properly. Here's what I've tested:
Column C row 3 has the string:
[Next Action] [This is a test]

worksheet formulas:
=FIND("[",C3,1) => 1 yes
=FIND("[",C3,2) => 15 yes
=FIND("]",C3,1) =>13 yes
=FIND("]",C3,2) =>13 wrong

was that something i didn't do right to come up with a wrong value or is that Excel defect?
Thanks!

 

[xlbo]

=FIND("]",C3,2) =>13
You get this because you put the start position for the find at position 2
There is a ] at pos 13 so whether you start at 1 or 2 doesn't matter....to find the last one of "]" you need to start at pos 14 ie AFTER the 1st one so
=FIND("]",C3,14)
will return the correct position. To get round this, you can use:
=FIND("]",C3,FIND("]",C3)+1)

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes
Get the best answers to your questions - faq222-2244