Results 1 to 3 of 3

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

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-19-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    140

    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
    Last edited by johnmerlino; 07-15-2011 at 04:11 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1