View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Replace mutiply sign *

Hi,

Put a Tilde in front of it and it will only replace the character and not
behave like a wildcard

~*

Mike

"jwang036" wrote:

I need to replace the * sign with something else. If I replace * with say /,
not only * sign but everything will be replace. Anyone knows how it can be
done? Thanks.