Multiple cells reference
Not that... I meant to list the values from multiple cells in a single cell.
Something like =A1&","&A2&","&A3&","&A4&","&A5&","&A6& etc but for a
looooong list of values. So, is there a short mode?
"Teethless mama" wrote:
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.
|