Creating a list of cell values

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.
 
S

Stefi

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

Regards,
Stefi

„Link†ezt írta:
 
L

Link

Thanks Stefi!!

You saved me lots of time. Concatenate was what I was after!

Cheers,
Link.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Creating Excel Formula 4
Formula prob - or is it validation? 10
FORMULA WHICH IGNORES POSITIVE VALUES 2
Leaving a cell blank 5
Conditional Printing 2
simple: Identify a cell that is out of number sequence in a list 10
Add cells 3
formula up to a maximum of 100, no greater than 1

Top