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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sebation - 13 Dec 2007 01:12 GMT

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

Reply to this Message

Ron Rosenfeld - 13 Dec 2007 01:27 GMT

>hi,
>till now ,the excel only support substitute the text in the cell,as we can
[quoted text clipped - 3 lines]
>Regars,
>Chelsea

What was wrong with using the SUBSTITUTE function?

e.g.

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

Reply to this Message

CLR - 13 Dec 2007 15:11 GMT

Try Edit > Replace, and follow the menu

Vaya con Dios,
Chuck, CABGx3

> hi,
> till now ,the excel only support substitute the text in the cell,as we can
[quoted text clipped - 3 lines]
> Regars,
> Chelsea

Reply to this Message