using vba to determine the positions of a character repeated twice in string

Hey all,

You can use the InStr function to determine the position of a character in a string. However, what if you want to determine the position of the character, which is used twice in the string? For example:

abc def & abc xyz & abc a

I would want to know the position of the first & and also the position of the second & using VBA.

Thanks for response

Please Login or Register  to view this content.