| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding a Character in a String Using VBA
Hi,
I am trying to return an integer for the number of characters from the left of a string that the character "/" is located. I need to do this using VBA as I am trying to trim the value of a cell. Can anyone help? BVass |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding a Character in a String Using VBA
Use the InStr function... InStr(start, string1, string2, compare type) -- Jim Cone Portland, Oregon USA "BVass" wrote in message Hi, I am trying to return an integer for the number of characters from the left of a string that the character "/" is located. I need to do this using VBA as I am trying to trim the value of a cell. Can anyone help? BVass |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding a Character in a String Using VBA
Thanks Jim....you are a life saver!!!!
"Jim Cone" wrote: Use the InStr function... InStr(start, string1, string2, compare type) -- Jim Cone Portland, Oregon USA "BVass" wrote in message Hi, I am trying to return an integer for the number of characters from the left of a string that the character "/" is located. I need to do this using VBA as I am trying to trim the value of a cell. Can anyone help? BVass |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check for character in string | Excel Discussion (Misc queries) | |||
| Finding a character in a text string (take3) | Excel Discussion (Misc queries) | |||
| find a character in a string | Excel Discussion (Misc queries) | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| Splitting Character String | Excel Worksheet Functions | |||
Linear Mode
