VBA to select specific words from a string

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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!