View original (French)

Replace Char * in Excel

Solved
yannpl7 Posted messages 1535 Status Membre -  
yannpl7 Posted messages 1535 Status Membre -
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 réponse

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