| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Character Locations in Strings
Is there a way to access individual characters within strings? In C++, you
can use brackets, but I don't know how to do it in VBA. i.e. word = "string" -- to access the 3rd charcter, I would use word[3] (or something like that) in C++. For VBA....? Thanks. Pflugs |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Character Locations in Strings
mid("string",3,1)
-- Tim Williams Palo Alto, CA "Pflugs" wrote in message ... Is there a way to access individual characters within strings? In C++, you can use brackets, but I don't know how to do it in VBA. i.e. word = "string" -- to access the 3rd charcter, I would use word[3] (or something like that) in C++. For VBA....? Thanks. Pflugs |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Character Locations in Strings
Thanks!
"Tim Williams" wrote: mid("string",3,1) -- Tim Williams Palo Alto, CA "Pflugs" wrote in message ... Is there a way to access individual characters within strings? In C++, you can use brackets, but I don't know how to do it in VBA. i.e. word = "string" -- to access the 3rd charcter, I would use word[3] (or something like that) in C++. For VBA....? Thanks. Pflugs |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Formating and building character strings | Excel Discussion (Misc queries) | |||
| testing for character strings within a cell | Excel Worksheet Functions | |||
| Character Locations in Strings | Excel Programming | |||
| Finding 13 character codes in text strings | Excel Worksheet Functions | |||
| VB 255 character limit for strings | Excel Programming | |||
Linear Mode
