Find and replace Excel, Office pro 2003
 

Hi,

I have a bit of a strange problem. In Excel 2003 (office 2003 prof.ent) I
want to Find and Replace within cells, more than in the Formulas (Comments
and Values as well). But Excel only presents me with Formulas as the only
option...See attachment.
Any solution/tip appreciated.

Best regards,

Bval

Hi Bval,

I have 2002 and in that as well within replace only formula option is
available. (Within Find all 3 options are available)

Dont know why MS has not provided this feature in Replace.

Thanks a lot,
Hari
India

"bval" wrote in message
...
Hi,

I have a bit of a strange problem. In Excel 2003 (office 2003 prof.ent) I
want to Find and Replace within cells, more than in the Formulas (Comments
and Values as well). But Excel only presents me with Formulas as the only
option...See attachment.
Any solution/tip appreciated.

Best regards,

Bval

And in Excel 97.........Replace has NO options.

Find has the 3 options.


Gord Dibben Excel MVP

On Thu, 27 Jan 2005 16:52:12 +0530, "Hari Prasadh"
wrote:

Hi Bval,

I have 2002 and in that as well within replace only formula option is
available. (Within Find all 3 options are available)

Dont know why MS has not provided this feature in Replace.

Thanks a lot,
Hari
India

"bval" wrote in message
...
Hi,

I have a bit of a strange problem. In Excel 2003 (office 2003 prof.ent) I
want to Find and Replace within cells, more than in the Formulas (Comments
and Values as well). But Excel only presents me with Formulas as the only
option...See attachment.
Any solution/tip appreciated.

Best regards,

Bval

The VALUE is calculated by the formula. If the input cells remain constant,
the only way to change the value is to change the underlying formula.

On Thu, 27 Jan 2005 16:52:12 +0530, "Hari Prasadh"
wrote:

Hi Bval,

I have 2002 and in that as well within replace only formula option is
available. (Within Find all 3 options are available)

Dont know why MS has not provided this feature in Replace.

Thanks a lot,
Hari
India

"bval" wrote in message
...
Hi,

I have a bit of a strange problem. In Excel 2003 (office 2003 prof.ent) I
want to Find and Replace within cells, more than in the Formulas (Comments
and Values as well). But Excel only presents me with Formulas as the only
option...See attachment.
Any solution/tip appreciated.

Best regards,

Bval

Just to add to Myrna's post:

="ha"&"ri"& " " & "Pra" & "sadh"

What should happen if you said to change "Hari Prasadh" to "Jim Johnson"?

And if some of those constants referred to cells?
=a1&b1&c1&d1&e1
but still evaluated to:
Hari Prasadh



Hari Prasadh wrote:

Hi Bval,

I have 2002 and in that as well within replace only formula option is
available. (Within Find all 3 options are available)

Dont know why MS has not provided this feature in Replace.

Thanks a lot,
Hari
India

"bval" wrote in message
...
Hi,

I have a bit of a strange problem. In Excel 2003 (office 2003 prof.ent) I
want to Find and Replace within cells, more than in the Formulas (Comments
and Values as well). But Excel only presents me with Formulas as the only
option...See attachment.
Any solution/tip appreciated.

Best regards,

Bval





--

Dave Peterson

Hi Dave and Myrna,

Thnx for a nice explanation. Im now able to appreciate why Value has not
been included.

What about Comments?

Thanks a lot,
Hari
India

"Dave Peterson" wrote in message
...
Just to add to Myrna's post:

="ha"&"ri"& " " & "Pra" & "sadh"

What should happen if you said to change "Hari Prasadh" to "Jim Johnson"?

And if some of those constants referred to cells?
=a1&b1&c1&d1&e1
but still evaluated to:
Hari Prasadh



Hari Prasadh wrote:

Hi Bval,

I have 2002 and in that as well within replace only formula option is
available. (Within Find all 3 options are available)

Dont know why MS has not provided this feature in Replace.

Thanks a lot,
Hari
India

"bval" wrote in message
...
Hi,

I have a bit of a strange problem. In Excel 2003 (office 2003 prof.ent)
I
want to Find and Replace within cells, more than in the Formulas
(Comments
and Values as well). But Excel only presents me with Formulas as the
only
option...See attachment.
Any solution/tip appreciated.

Best regards,

Bval





--

Dave Peterson

That's a good question. And I don't have a guess why they were excluded.

Hari Prasadh wrote:

Hi Dave and Myrna,

Thnx for a nice explanation. Im now able to appreciate why Value has not
been included.

What about Comments?

Thanks a lot,
Hari
India

"Dave Peterson" wrote in message
...
Just to add to Myrna's post:

="ha"&"ri"& " " & "Pra" & "sadh"

What should happen if you said to change "Hari Prasadh" to "Jim Johnson"?

And if some of those constants referred to cells?
=a1&b1&c1&d1&e1
but still evaluated to:
Hari Prasadh



Hari Prasadh wrote:

Hi Bval,

I have 2002 and in that as well within replace only formula option is
available. (Within Find all 3 options are available)

Dont know why MS has not provided this feature in Replace.

Thanks a lot,
Hari
India

"bval" wrote in message
...
Hi,

I have a bit of a strange problem. In Excel 2003 (office 2003 prof.ent)
I
want to Find and Replace within cells, more than in the Formulas
(Comments
and Values as well). But Excel only presents me with Formulas as the
only
option...See attachment.
Any solution/tip appreciated.

Best regards,

Bval





--

Dave Peterson

--

Dave Peterson