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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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)"

the code above... WORKS!