How to delete Certain Characters in a excel 2010 cell -

in column have load of name this

[john smith]

i still want them in [] removed...

if [john smith] in cell a1, use formula want:

=substitute(substitute(a1, "[", ""), "]", "") 

the inner substitute replaces instances of "[" "" , returns new string, other substitute replaces instances of "]" "" , returns final result.