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!