how to use replace function in excel 97

[kamal]

please tell me if there is " Replace " function available in excel 97
if not then is there any alternative

 

[Kieran]

kamal,
Yes, replace does exist.

Look int eh edit menu or press Ctlr-r to locate the function.

I believe that help is quite instructive too

 

[Norman Harker]

Hi Kamal!

Try using Help. It's a text function so it shouldn't take a lot of
finding.

=REPLACE(old_text,start_num,num_chars,new_text)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Arvi Laanemets]

Hi

=SUBSTITUTE(TextString,OldText,NewText,Instance)
P.e.
=SUBSTITUTE(SUBSTITUTE("Microsoft","i","a"),"soft","flex")

 

[Bob Phillips]

Kamal,

I know you posted this in the worksheetfunctions group, but it is such an
odd question, I wonder if you are asking about a VBA Replace?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)