Good afternoon tobriant

You can use Find or Search, however you probably want the latter as it
is not case sensitive, and will return the number of characters at
which your string is first found, if your string isn't found then a
#VALUE! error is returned.

=SEARCH("first bank",A1)

will search for the string in cell A1. You can start searching from a
specified point in a string (which would come after the A1) but if not
specified then 1 is used.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=469191