VBA to select specific words from a string

cw36 · Jun 12th 2022

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!

**KjBox** · Jun 12th 2022

This should get you started

Code

Sub ExtractFTs()
    Dim x, i&, s$
    
    x = Split(ActiveCell, ", ")
    For i = LBound(x) To UBound(x)
        If x(i) Like "FT*" Then
            If s = vbNullString Then
                s = x(i)
            Else
                s = s & ", " & x(i)
            End If
        End If
    Next
    MsgBox s
    
End Sub

Display More

VBA to select specific words from a string

Participate now!

Share

Similar Threads

Have a VBA String-Array To Point to a Specific Cell of Another String Array

Add pre-defined text to a cell based on input from a different cell

Using vba to search within a excel table for a specific value

VBA - How to exclude rows from search results if a cell is = to a specific value

Create Outlook Item with specific set of pdf files from specific folder for specific emails

Extract Specific Text from a Cell