Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating a list of cell values
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating a list of cell values
Maybe you mean concatenation:
Enter in A4: =A1 & "," & A2 & "," & A3 Regards, Stefi €˛Link€¯ ezt Ć*rta: 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating a list of cell values
Thanks Stefi!!
You saved me lots of time. Concatenate was what I was after! Cheers, Link. "Stefi" wrote in message ... Maybe you mean concatenation: Enter in A4: =A1 & "," & A2 & "," & A3 Regards, Stefi "Link" ezt ķrta: 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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Creating a list of cell values
You are welcome! Thanks for the feedback!
Stefi €˛Link€¯ ezt Ć*rta: Thanks Stefi!! You saved me lots of time. Concatenate was what I was after! Cheers, Link. "Stefi" wrote in message ... Maybe you mean concatenation: Enter in A4: =A1 & "," & A2 & "," & A3 Regards, Stefi "Link" ezt Ć*rta: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a range reference from cell values | Excel Discussion (Misc queries) | |||
Creating A Unique List of Values From A Table | Excel Worksheet Functions | |||
Creating a horizontal list of text values | Excel Discussion (Misc queries) | |||
Creating a link from cell values | Excel Discussion (Misc queries) | |||
Creating cell references with variable values to use in Vlookup | Excel Discussion (Misc queries) |