replace values between specific characters

thanks! the above worked perfectly.

however, i now have to adapt this to remove anything between "<" and " " and everything within "<" and " "

i modified the above to:

Function RemoveBrackets(aString As String) As String
    Dim i As Long, Snippets As Variant
    aString = Application.Substitute(aString, "<", " ")
    Snippets = Split(aString, " ")
    For i = 0 To UBound(Snippets) Step 2
        RemoveBrackets = RemoveBrackets & Snippets(i)
    Next i
End Function

but when i ran it, it is cutting out too much. i guess because there is a "space" between the text strings, and it's spliting it?

for example:

<randomstring testing number 444 <randomstring user number 8394 <!code… activated account

with my adapted code it becomes:

testing444randomstringnumberactivated

but what i want is:

testing number 444 user number 8394 activated account

effectively removing anything between "<" and "space":

<randomstring

<randomstring

<!code…

any ideas? thanks in advance!

thanks for the quick response =D

i am getting this in Microsoft Visual Basic Editor after trying out the code:

Compile error: Argument not optional

Then it highlights the "Left" in the

If Left(Snippets(i)) <> "<" Then

string

i am running excel 07, and i hope that doesn't make a difference? thanks again!

thanks again! error is gone

but, the returned value is now #NAME? or 0?
input string is

<randomstring testing number 444 <randomstring user number 8394 <!code… activated account

and formula used is:

=RemoveBrackets(A2)

the code i am using:

Function RemoveBrackets(aString As String) As String
    Dim i As Long, Snippets As Variant
    Snippets = Split(aString, " ")
    For i = 0 To UBound(Snippets) Step 2
        If Left(Snippets(i), 1) <> "<" Then
            RemoveBrackets = RemoveBrackets & Snippets(i)
        End If
    Next i
End Function

i tried to change the code some more... but it's not working out. arrrrr, ahahah, this coding stuff is not as easy as it seems.

is there a find/replace string that can do this?

for example, is there a wildcard character that can be used to represent the characters within the string?

e.g.) "<*******(space)"