View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default replace in a string

On Sun, 11 Sep 2005 10:22:56 GMT, "M" wrote:

Hi,

I'm looking for a code which performs the following :
delete a string from another string :
example : tomorrow --- the m should be removed
--- output : toorrow

Thanks


Look at HELP for the SUBSTITUTE worksheet function.

=SUBSTITUTE("tomorrow","m","")

will remove all of the "m"'s.


--ron