Re: Replacing occurence of string in another string
From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/11/04
- Next message: Frank Kabel: "Re: Remove space in character one"
- Previous message: Frank M.: "Replacing occurence of string in another string"
- In reply to: Frank M.: "Replacing occurence of string in another string"
- Next in thread: JE McGimpsey: "Re: Replacing occurence of string in another string"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Mar 2004 15:18:31 +0100
Hi Frank
try
=SUBSTITUTE(A1,"old_str","new_str")
-- Regards Frank Kabel Frankfurt, Germany Frank M. wrote: > Suppose I have a string value with many lines of text. Within it > there is several place holders (e.g. <xxx>) and that I want to change > the text replacing the place holders with different strings to make a > final text. > > Is there a function for replacing one or all occurences of a string > withing another string, or do I have to make a function myself > through use of for example the InStr function? > > > Regards, > > Frank M.
- Next message: Frank Kabel: "Re: Remove space in character one"
- Previous message: Frank M.: "Replacing occurence of string in another string"
- In reply to: Frank M.: "Replacing occurence of string in another string"
- Next in thread: JE McGimpsey: "Re: Replacing occurence of string in another string"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
