How do I find a specific characters position in a string varia
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!!
" 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
|