Macro loop removing extra underscores XL 2010

Version: Excel 2010

Hi,

I need to create a macro which loops over a range of cells and removes extra underscores from the cell contents. It would be nice if the macro could also remove any underscores that appear before and after the brackets. E.g. :

ab_c becomes ab_c
ab__c becomes ab_c
a____________________b__c becomes a_b_c
(_abc) becomes (abc)
(ab__c_____) becomes (ab_c)

I am having trouble figuring out how to do this, any help from the experts would be much appreciated!

Thanks!!

Dan

Please Login or Register  to view this content.

I need to create a macro which loops over a range of cells ...

Any particular range?

Thanks this worked!

I needed it for a certain range within a column, but I figured it out just as much

Thanks for your help Steven!!