J
Javad
Hello
I would like to know what's the easiest way to add a specaial character to
the beginning of all the cells in a selected area in Excel.
For example I have these records in cells A1 to A3:
2*3
2*4
2*5
Now I want them to be something like this:
=2*3
=2*4
=2*5
(I want to convert them into formulas)
How can I do this? I know some complex ways to do this such as putting a "="
character in "B1 to B3" and then writing this formula in C1 to C3: "=A1&B1"
and then...
or I can also write a macro for this, but I'm looking for a very simple and
easy way. Is there an easy way to do it?
Thank you
I would like to know what's the easiest way to add a specaial character to
the beginning of all the cells in a selected area in Excel.
For example I have these records in cells A1 to A3:
2*3
2*4
2*5
Now I want them to be something like this:
=2*3
=2*4
=2*5
(I want to convert them into formulas)
How can I do this? I know some complex ways to do this such as putting a "="
character in "B1 to B3" and then writing this formula in C1 to C3: "=A1&B1"
and then...
or I can also write a macro for this, but I'm looking for a very simple and
easy way. Is there an easy way to do it?
Thank you