Find a value in a cell and display LEN location??

[Fyr]

I'll try my best to explain this.
I have CSV files that are opened and data is read for them.
I'm looking for a script that find's a certain value in cell "A1" and displays it's located by LEN.

So lets say cell "A1" contains

BDIR)\\HTO\ASERV30\IMG\IN\1119654652202BD000000001119654652202BTNB1119654652202BTRETCT9BTSRCASCAN BTTYOCFOCBN 1119654652202DREC20110714DTSCN20110714TSTESNMRD 052011

I want to find data "DTSCN". The script would return LEN 136.
Is this possible?

 

[njimack]

=search("dtscn",a1)

 

[Fyr]

That worked perfectly if I put it in a cell.
But how do I do that with VBA?

I know this is not right:
Search("DTSCN", Range("A1"))

 

[njimack]

WorksheetFunction.Search("DTSCN", Range("A1"))

 

[jasonb75]

Try

MsgBox InStr([A1], "DTSCN")

Note that InStr is case sensitive so you may prefer

MsgBox InStr(UCase([A1]), "DTSCN")

 

[Fyr]

Thank you njimack that worked perfectly!!
jasonb75, that also worked! thank you!