VBA Code to remove square brackets and the data contained in them.

Hi all,

I a piece of VBA to remove square brackets and the data within it in excel:

Here's an example of what my sheet currently looks like against how i want it to look.

1.png

Thanks,
Liam

You could do this with Find ([*]) and Replace (leave box blank). Or with VBA

Please Login or Register  to view this content.

Thanks, nice & simple