I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

do you mean you need to REPLACE your factor X into factor Y?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

Yes


"4pinoy" wrote:

do you mean you need to REPLACE your factor X into factor Y?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

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 ?

"Office Jnr" wrote:

Yes


"4pinoy" wrote:

do you mean you need to REPLACE your factor X into factor Y?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

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.

"Office Jnr" wrote:

Yes


"4pinoy" wrote:

do you mean you need to REPLACE your factor X into factor Y?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

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.


"4pinoy" wrote:

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 ?

"Office Jnr" wrote:

Yes


"4pinoy" wrote:

do you mean you need to REPLACE your factor X into factor Y?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

Have you considered Find/Replace? in the edit menu?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

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

"Rookie 1st class" wrote:

Have you considered Find/Replace? in the edit menu?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

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"
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




"Rookie 1st class" wrote:
Have you considered Find/Replace? in the edit menu?



"Office Jnr" wrote:
I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

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


On Sat, 11 Nov 2006 14:51:01 -0800, Office Jnr
wrote:

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

"Rookie 1st class" wrote:

Have you considered Find/Replace? in the edit menu?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

But of course A12*12 becomes A21*21
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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


On Sat, 11 Nov 2006 14:51:01 -0800, Office Jnr
wrote:

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

"Rookie 1st class" wrote:

Have you considered Find/Replace? in the edit menu?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a
number
multiplied by X to the same number multiplied by Y

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 "=".....?

"Office Jnr" wrote:

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

"Rookie 1st class" wrote:

Have you considered Find/Replace? in the edit menu?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

Yep.

You're correct. Too quick with the trigger finger.

Thanks David.


Gord




On Sat, 11 Nov 2006 23:24:37 -0000, "David Biddulph"
wrote:

But of course A12*12 becomes A21*21

Gord Dibben MS Excel MVP

Jnr?

"David Biddulph" wrote:

But of course A12*12 becomes A21*21
--
David Biddulph

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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


On Sat, 11 Nov 2006 14:51:01 -0800, Office Jnr
wrote:

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

"Rookie 1st class" wrote:

Have you considered Find/Replace? in the edit menu?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a
number
multiplied by X to the same number multiplied by Y

i dont know why it mostly freeze a question when i log in...? Are u still
there ?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

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.

"Gord Dibben" wrote:

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


On Sat, 11 Nov 2006 14:51:01 -0800, Office Jnr
wrote:

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

"Rookie 1st class" wrote:

Have you considered Find/Replace? in the edit menu?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

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"

"4pinoy" wrote:

i dont know why it mostly freeze a question when i log in...? Are u still
there ?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y

Have you tried with the tilde(~) as Jim Cone suggested?

Replace what: ~*12

With: ~*21


Gord

On Sun, 12 Nov 2006 06:00:02 -0800, Office Jnr
wrote:

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"

"4pinoy" wrote:

i dont know why it mostly freeze a question when i log in...? Are u still
there ?

"Office Jnr" wrote:

I would like to change all cells on a spreadsheet that contain a number
multiplied by X to the same number multiplied by Y


Gord Dibben MS Excel MVP