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

  • Thread starter Thread starter Sebation
  • Start date Start date
S

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
 
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
Click to expand...

What was wrong with using the SUBSTITUTE function?

e.g.

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