View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chad[_12_] Chad[_12_] is offline
external usenet poster
 
Posts: 49
Default remove text between [ ]

Hi

I wanted to remove the brackets and text within them using vba. In
each cell I have the item;

There [has to be an answer] it is.

Where the result after running the process is ;

There it is.

I have been searching for hours and can't seem to find anything that
specifically gets this done.

Any help or pointers greatly appreciated.

Chad