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
|