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

G

Guest

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
 
G

Guest

excelmastery?!!?

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

Guest

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

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

Find Character Position in String 6
How to move worksheet into specific position? 3
Trying to find an "A" in the last position of a variable length Part Number in Cell 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Finding an exact string in a range 5
VBA: How can I use a string variable as autofilter criteria? 4
Interogating a string within a Macro 3
How to find the first occurence of any number in a string 2

Top