how can i susbstitute the symboals like '-' or¡®#¡¯ in the cell?

[Sebation]

hi,
till now ,the excel only support substitute the text in the cell,as we can
use SUBSTITUE function.
But if i want to substitue the symboals like ¡®-¡¯ or¡®#'£¬how can i do?

Regars,
Chelsea

 

[Ron Rosenfeld]

hi,
till now ,the excel only support substitute the text in the cell,as we can
use SUBSTITUE function.
But if i want to substitue the symboals like ¡®-¡¯ or¡®#'£¬how can i do?

Regars,
Chelsea

What was wrong with using the SUBSTITUTE function?

e.g.

=SUBSTITUTE(A1," ","®",1)
--ron

 

[CLR]

Try Edit > Replace, and follow the menu

Vaya con Dios,
Chuck, CABGx3