Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find replace text or symbol with carriage return | New Users to Excel | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
How Can I find and replace symbols in excel data ( white square) | Excel Discussion (Misc queries) | |||
VB Find and Replace | Excel Worksheet Functions | |||
boolean find criteria in Excel | Excel Discussion (Misc queries) |