Macro to delete all data contained within <>

[tcopeland]

I am working on an large excel workbook. On of the coloum contains email addresses, we want to clean it up to just show the name - is there a formula that would find and replace the information contained within <> with a space?

Ex. T. Copeland<copeland@yahoo.com) - I only T. Copeland to remain - there are over 500 different e-mail addresses.

Thanks

 

[jproffer]

If a formula would due, you could use:

=REPLACE(B2,2,9999," >")

Change B2 to whatever suits you...drag down as far as you like.