| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I find a specific characters position in a string variable
i = instr(string, what)
HTH -- AP " a écrit dans le message de ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I find a specific characters position in a string variable
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find a text in a string without giving the position of the | Excel Discussion (Misc queries) | |||
| Text String - Specific Characters | Excel Worksheet Functions | |||
| find nth position of a string | Excel Discussion (Misc queries) | |||
| find position of a number in a string | Excel Worksheet Functions | |||
| How find character position # in string from right end? Or how get range row num | Excel Programming | |||
Linear Mode
