Remove text between [brackets]

Hi @ all,

I use a macro for deleting a text between two brackets in a range("a1:a6000").

Please Login or Register  to view this content.

it works fine but only for the first pair of brackets:

something like "cars[ss,s,c]" becomes "cars"

but:

auto[o,au]mo[o,au]bi[i,ay,ai]le becomes automo[o,au]bi[i,ay,ai]le


how can I modify the code to delete all the text between all the bracket pairs in a cell ?


Many thanks in advance for any help!
Gr.Benni

Hi Benni5555,

Welcome to the forum!!

I may have a solution but you just need to wrap your code in appropriate tags like this:

[CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]

...before I can post it as it's a requirement of the forum.

Regards,

Robert

Hello Benni5555,

Welcome to the Forum! This will do it.

Please Login or Register  to view this content.

Hi Benni5555

Try this code

Please Login or Register  to view this content.

Edit : Hi Leith Ross, very good ;-)

Regards,

Thanks for adding the tags

Though you've got a solution (nice one Leith), here's my proposed solution in any case:

Please Login or Register  to view this content.

Regards,

Robert