Multiple cells reference
Drag the Fill Handle from C1 to C20
"Elis" wrote:
thank you!
now, is it possible for a range of cells? (A2 to A20)
"tim m" wrote:
If 44 was in A1 and 55 was in B1 you could use:
=A1&","&B1 and it will give you 44,55 (Just change what is between the
quotation marks of you want a semi colon or a space instead of the comma.)
"Elis" wrote:
Let's suppose the following facts:
I have two cells, each one containing one number.
I want to make a refference of the two values that I need to view in a third
cell, separated by commas or ";" or anything else.
So, if two cells have the "44" and "55" vallues, can I have a third cell
that will contain the following value: "44,55" or "44;55" or "44 55"?
Please help me if there's any chance.
Thanks.
|