Looping though multiple strings

Your syntax is wrong, but why can't you reference using the Mid formula?

E.g Letter 4 = Mid(String, 4, 1)

It would be easier to either

1) have a variable that you pass to a mid function to return the letter

2) create an array where each element holds a letter
so an array called mystring and the string "Test String"
mystring(0) = T
myString(1) = e
etc...

And you pass a variable to mystring(x - 1) where x is the position you want.

Could you not just refer to the letter directly in the array, rather than a variable?

Please Login or Register  to view this content.

You can certainly refer to it directly, i just was unsure of his needs. Maybe he wants to type in a # in a cell and pass back the correspinding letter? I dunno, was just giving him options. The best way would just stick with Mid though as stephen said.

Originally Posted by StephenR

Your syntax is wrong, but why can't you reference using the Mid formula?

E.g Letter 4 = Mid(String, 4, 1)

The reason I did not go that way is because the text string lenght is always going to be changing and each time the code runs there will be a diff amount of Letter1....

Thanks to everyone
Kyles approached worked best for me.
I’m sorry I did not completely explain what I was doing but I did not know where to begin.
In short I am breaking down diagnosis that have similar looking strings to make them noticeably different, to prevent misinterpretation
Thanks Again