Creating a list of cell values

  • Thread starter Thread starter Link
  • Start date Start date
L

Link

Hi All

I have three cells:

A1 with the value of 1
A2 with the value of 2
A3 with the value of 3.

I would like A4 to read 1,2,3. Is there an easy way to do this in Excel? I
though it may be a list but that doesn't seem to be the case.

I also tried =A1, =A2, =A3, but that produced nada.

Any help apprciated!

Cheers,
Link.
 
Maybe you mean concatenation:
Enter in A4:
=A1 & "," & A2 & "," & A3

Regards,
Stefi

„Link†ezt írta:
 
Back
Top