View original (French)

Replace Char * in Excel

Solved
yannpl7 Posted messages 1535 Status Member -  
yannpl7 Posted messages 1535 Status Member -
Hello,
I want to replace all the * characters in an Excel file with something else.
How can I do that because when I use the replace function, it replaces all the text.
Thank you

--
the one who holds the knowledge holds the power
Configuration: Windows XP Internet Explorer 6.0

1 answer

  1. tontong
     
    Hello,
    to replace a wildcard character like * it must be preceded by the tilde ~. Replace: ~*
    3
    1. yannpl7 Posted messages 1535 Status Member 305
       
      Thank you
      --
      he who holds knowledge holds power
      0