K
kamal
please tell me if there is " Replace " function available in excel 97
if not then is there any alternative
if not then is there any alternative
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
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
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
N
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.
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.
A
Arvi Laanemets
Hi
=SUBSTITUTE(TextString,OldText,NewText,Instance)
P.e.
=SUBSTITUTE(SUBSTITUTE("Microsoft","i","a"),"soft","flex")
=SUBSTITUTE(TextString,OldText,NewText,Instance)
P.e.
=SUBSTITUTE(SUBSTITUTE("Microsoft","i","a"),"soft","flex")
B
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)
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)