VBA to select specific words from a string

  • Hi guys! I want to write a section of code that will extract specific words from a string, then use those extracted words to form a new string. The initial string looks like this: FT1, FT2, PT2, FT3.

    I would like to extract all the words with "FT*" and create the string "FT1 + FT2 + FT3". Any help is appreciated!

  • This should get you started

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!