Need to remove brackets while displaying data in the output in Excel Template

Hi All,

We developed the Excel template as per the requirement but in one of the column is having ‘[‘ and ‘]’  anywhere in the data . We don’t want those brackets in the output.  We are unable to use replace function in the excel template.

For Ex:

Dname

----------

[xyz]

A[bcdf]hj

Qweasd[kjl]

 

Please suggest.

Thanks,

Visu