Lookup specifik number in a text cell

[johannordgren]

Hello there,

I have a file set as the table below. I want to be able to change the "(3)" to any given number in one cell, doing so in all cells, but no the actual card number.
I want the setup to be like the 1:st column, and not like the 2:nd.
Might add that these cells are not connected to eachother, so any type of "fill" soloution is not an option.
Hope, I've made myself clear, but feel free to ask if I havn't!
[TABLE="width: 500"]
<tbody>[TR]
[TD]Card 1 (3)
[/TD]
[TD]Card 1 (3)
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Card 2 (3)
[/TD]
[TD]Card 1 (3)
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Card 3 (3)
[/TD]
[TD]Card 1 (3)
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

This would change 3 to a 4 for example:

=SUBSTITUTE(A1,"(3)","(4)")

Or just use built in CTRL-H

Find what (3)
Replace with (4)

 

[johannordgren]

This would change 3 to a 4 for example:

=SUBSTITUTE(A1,"(3)","(4)")

Or just use built in CTRL-H

Find what (3)
Replace with (4)

Not quite what I'm looking for.
[TABLE="class: cms_table, width: 500"]
<tbody>[TR]
[TD]Card 1 (3)[/TD]
[TD]Card 1 (4)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Card 2 (3)[/TD]
[TD]Card 2 (4)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Card 3 (3)[/TD]
[TD]Card 3 (4)
[/TD]
[/TR]
</tbody>[/TABLE]
This is what i want. If I change the "(x)" in the first cell, I want that number to change in the rest aswell, without anything else changing. Or do I missuse the formula you gave me?

As you say there is the replacement tool, but I would like it to bu simpler than that.

 

[steve the fish]

There isnt anything more simple than the replace tool for what you describe. If you change a cell and want others to change they either need to be formulas dependant on the original changed cell or you need VBA.