Interogating a string within a Macro

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

Guest

If I have a string called data that contains, for example, 12 characters how
can I find teh position of two charactors within it.

e.g the string is :
abhhsctdshhd

how can I find the position of 'ct' within it ?

any suggestions appreciated.

brian
 
If I have a string called data that contains, for example, 12 characters how
can I find teh position of two charactors within it.

e.g the string is :
abhhsctdshhd

how can I find the position of 'ct' within it ?

any suggestions appreciated.

brian
Click to expand...


InStr Function

Returns a Variant (Long) specifying the position of the first occurrence of one
string within another.

Syntax

InStr([start, ]string1, string2[, compare])


--ron
 

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

interogating a string within a macro - bjy 1
Find postion of number character within a string 2
How do I find a specific characters position in a string variable 3
Character Locations in Strings 3
Help with Replace() 11
Find coding 5
how do i include an excel formula in a vb string? 2
Bold items within text string 7

Back
Top