Character Locations in Strings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thanks!

Tim Williams said:
mid("string",3,1)

--
Tim Williams
Palo Alto, CA


Pflugs said:
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
Click to expand...
Click to expand...
 

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

Character Locations in Strings 3
Separating parts of a string in VBA 4
Macro that will insert a simple text string in top cell of text file 1
Excel 2003 VBA string literal help location 9
Count font colour in a cell 2
Passing SQLPlus script location using Windows Script Host Object Model 11
Delete 1st character if string is longer than 6 characters 3
Sets of Characters in Excel VBA 5

Back
Top