O
Office Jnr
I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y
multiplied by X to the same number multiplied by Y
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.
4
4pinoy
do you mean you need to REPLACE your factor X into factor Y?
O
Office Jnr
4
4pinoy
1. Do all cells that contain a number is obtained under a formula ?
2. How many times do you use the Factor X in one formula ?
2. How many times do you use the Factor X in one formula ?
O
Office Jnr
almost like - Edit- find "*12" - Replace all with "*21". When I do this
instead of keeping the figure that is being multiplied and multiplying it by
21 it i replacing the whole cell content with "*21" only.
instead of keeping the figure that is being multiplied and multiplying it by
21 it i replacing the whole cell content with "*21" only.
O
Office Jnr
It is like "A*6.4" and i want to change this to "A *13.5", but the figure A
varies in many other cells. I want to keep the figure A but find and replace
all is replacing with *13.5 only.
varies in many other cells. I want to keep the figure A but find and replace
all is replacing with *13.5 only.
R
Rookie 1st class
Have you considered Find/Replace? in the edit menu?
O
Office Jnr
Yes I have tried this: eg in "A*12*" Find *12 Replace with *21 instead of
giving me A*21 it replaces the whole cell content with just *21
giving me A*21 it replaces the whole cell content with just *21
J
Jim Cone
Add a tilde "~" in front of the asterisk.
That changes the asterisk from a wildcard character to just an asterisk.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Office Jnr" <[email protected]>
wrote in message
Yes I have tried this: eg in "A*12*" Find *12 Replace with *21 instead of
giving me A*21 it replaces the whole cell content with just *21
That changes the asterisk from a wildcard character to just an asterisk.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Office Jnr" <[email protected]>
wrote in message
Yes I have tried this: eg in "A*12*" Find *12 Replace with *21 instead of
giving me A*21 it replaces the whole cell content with just *21
G
Gord Dibben
I don't know if/why you are actually including the quotes and the * in your
replace, but try just entering the numbers alone.
Assuming formula is =A1*12
Replace what: 12
Replace with: 21
Replace.
Will now have =A1*21
Gord Dibben MS Excel MVP
replace, but try just entering the numbers alone.
Assuming formula is =A1*12
Replace what: 12
Replace with: 21
Replace.
Will now have =A1*21
Gord Dibben MS Excel MVP
D
David Biddulph
But of course A12*12 becomes A21*21
4
4pinoy
again...Office.Jnr...is the factor a number or a cell ref (e.g. A1,X1....) ?
or a pure number 123....Aren't you sure if it is after "*" or after "=".....?
or a pure number 123....Aren't you sure if it is after "*" or after "=".....?
G
Gord Dibben
Yep.
You're correct. Too quick with the trigger finger.
Thanks David.
Gord
Gord Dibben MS Excel MVP
You're correct. Too quick with the trigger finger.
Thanks David.
Gord
But of course A12*12 becomes A21*21
Gord Dibben MS Excel MVP
4
4pinoy
4
4pinoy
i dont know why it mostly freeze a question when i log in...? Are u still
there ?
there ?
O
Office Jnr
if I just lookup 12 it could replace all the other figures on the spreadsheet
thar are just 12 but are not multiplying anything. Lets say for example I
had a figure 12*12 and I wanted to put in multiplied by 21 - 12*21. It would
end up 21*21. I think this is what Biddulph meant as well.
thar are just 12 but are not multiplying anything. Lets say for example I
had a figure 12*12 and I wanted to put in multiplied by 21 - 12*21. It would
end up 21*21. I think this is what Biddulph meant as well.
O
Office Jnr
Sorry had given up and went to sleep UK time.
The factor is a number. I know the easiest way would be to replace with a
cell as a multiplying factor and then always do th changes there But I am
using someone's spreadsheet and don't want to "step on their toes"
The factor is a number. I know the easiest way would be to replace with a
cell as a multiplying factor and then always do th changes there But I am
using someone's spreadsheet and don't want to "step on their toes"
G
Gord Dibben
Have you tried with the tilde(~) as Jim Cone suggested?
Replace what: ~*12
With: ~*21
Gord
Gord Dibben MS Excel MVP
Replace what: ~*12
With: ~*21
Gord
Sorry had given up and went to sleep UK time.
The factor is a number. I know the easiest way would be to replace with a
cell as a multiplying factor and then always do th changes there But I am
using someone's spreadsheet and don't want to "step on their toes"
Gord Dibben MS Excel MVP