Remove Certain Characters?

[Toki]

Hey all!

I was wondering if there was a way to remove a certain character from a column of cells.

For example:

Column A has a bunch of words with the symbol "]" & "[" surrounding them.
like this - [word]

Is there a way to just remove all these brackets from the words?

Thanks!

 

[pboltonchina]

Use the Edit- Replace function

 

[njimack]

Easiest way - select the cells, use Find & replace (Ctrl+H) - replace "[" with "", then repeat for "]"

 

[Toki]

Thanks njimack that did the trick!