How do I find a specific characters position in a string variable

Hi
I need to find the position of a particular character in a string variable
within a macro.

I can do this using the command =FIND(" ",B2) in an excel sheet to return
the position of the first space in the string in Cell B2.

What is the equivilent in VBA?

I am using Excel XP (2002)

Thanks
Paul

i = instr(string, what)

HTH
--
AP

"[email protected]" <[email protected]> a
écrit dans le message de
news:[email protected]...
> Hi
> I need to find the position of a particular character in a string variable
> within a macro.
>
> I can do this using the command =FIND(" ",B2) in an excel sheet to return
> the position of the first space in the string in Cell B2.
>
> What is the equivilent in VBA?
>
> I am using Excel XP (2002)
>
> Thanks
> Paul
>

excelmastery?!!?

Dude. You've totally got to get with inStr(). You will know bounty!!



"[email protected]" wrote:

> Hi
> I need to find the position of a particular character in a string variable
> within a macro.
>
> I can do this using the command =FIND(" ",B2) in an excel sheet to return
> the position of the first space in the string in Cell B2.
>
> What is the equivilent in VBA?
>
> I am using Excel XP (2002)
>
> Thanks
> Paul
>

David
Worked great, I new it would be simple but I normally do financial models
and work with numbers not text.
Thanks
Paul

"David" wrote:

> excelmastery?!!?
>
> Dude. You've totally got to get with inStr(). You will know bounty!!
>
>
>
> "[email protected]" wrote:
>
> > Hi
> > I need to find the position of a particular character in a string variable
> > within a macro.
> >
> > I can do this using the command =FIND(" ",B2) in an excel sheet to return
> > the position of the first space in the string in Cell B2.
> >
> > What is the equivilent in VBA?
> >
> > I am using Excel XP (2002)
> >
> > Thanks
> > Paul
> >